Can anyone tell me how to get the total number of records in a recordset by using "Select count(*) from table" in VB 5.0?
Printable View
Can anyone tell me how to get the total number of records in a recordset by using "Select count(*) from table" in VB 5.0?
rs.Open "SELECT COUNT(*) FROM mytable"
Debug.print rs.Fields(0)
rs.Close
Crazy D :-)
"One ring rules them all"