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")
 
Back
Top