finding total no. of records
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.