I have fields "Singer","Song" in a Table "Album"

Now i want to run a combination of SQL Query & other functions combined so that i finally get hold of the total no. of songs sung by each different Singer existing in the "singer" field

i tried using RecordCount propert of Recordset but it dint work out.

how do i do this.

To get a list of the singers and the number of records for each singer (ie the number of songs) use:

select Singer, count(Singer) from Album group by Singer.

This assumes that there is only one record for each singer and song combination.

Rod

======================================
They say, best men are moulded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================