Displaying Number of Records

[Guest_imported]

How can i display the number of records in a table. I want to use a report to display the number of records in a customer table..for example 290 customers to date....how do i do this....Auto-number does not work because there are problems when a record is deleted....and help would be VERY much appreciated

 

[dvrobin]

You could try "Select count(*) from mytable". Alternatively, you can access the recordcount using the ADO Recordset object's recordcount property. You need to use a client-side cursor that is not forward-only in order to do this.

In your report, you should also be able to add a field with the control source property set to "=count(myfield)".
Dave Robinder, MCSD
Programmer
Colorado DataScapes
Colorado Springs, CO
(719) 328-1111

 

[Guest_imported]

Thank you Soooooo very much....it worked perfectly...thank you