Databse ?s

[Chris_SE]

How do I output the number of records in a database? I've tried recordset.count and the .count but always get an error

[crispin]

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...

[Chris_SE]

forgot to mention, I am using SQL

[crispin]

I think you should be ok with the SQL above...

[Chris_SE]

...