How do I output the number of records in a database? I've tried recordset.count and the .count but always get an error
Printable View
How do I output the number of records in a database? I've tried recordset.count and the .count but always get an error
you may have to do a recordset.movelast and then a .movefirst before you can actually get the actual recordcount.
failing that try this SQL:
Select count(*) FROM tablename AS NumOfRecords.
Once executed open this recordset, movefirst, then
grab the value of recordset.fields("NumOfRecords")
see what that gives you...
forgot to mention, I am using SQL
I think you should be ok with the SQL above...
...