I have the 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 property of Recordset but it dint work out.

how do i do this.

What you might want to try is a combination of 2 recordsets.

The first recordset pulls the name inside of singer.
Inside the loop of this recordset, have another recordset to pull the songs by this singer.

ex SQL: SELECT COUNT(Songs) FROM Album WHERE Singer = " & Recordset1.Fields.Item(i).Value