how can I count records ?

  • Thread starter Thread starter Roger
  • Start date Start date
R

Roger

How can I count the number of records in a table so that I can use the
number obtained in a calculation ? I cannot use the ID autonumber for the
last record input as from time to time records get deleted and there are
numbers missing in the ID number sequence. I need to know the actual number
of records in the table at any one time.... Roger
 
How can I count the number of records in a table so that I can use the
number obtained in a calculation ? I cannot use the ID autonumber for the
last record input as from time to time records get deleted and there are
numbers missing in the ID number sequence. I need to know the actual number
of records in the table at any one time.... Roger
Click to expand...

=DCount("*","TableName")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber restarting after compact and repair 4
Access Dcount (multiple criteria) 3
Counting the sum of related records for a primary record 4
How to count consecutive records base on 2 groupings 0
Dcount returning no results!!! 0
Access 2007 - check for existing record 1
counting records 0
Count text values in a Access Field 0

Back
Top