SQL Query in VB 5.0

[sle]

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?

[Crazy D]

rs.Open "SELECT COUNT(*) FROM mytable"
Debug.print rs.Fields(0)
rs.Close

Crazy D :-)
"One ring rules them all"