Number of Records

[99mel]

I've been asked to create a simple feature on my database. All it is, is to have the total number of records in a certain table calculated. It sounds very simple but I'm not sure how to do it. Is there a record count or something (apart from the ID on a table)???<br>
<br>
Can anyone help??

 

[bitbrain]

Use the DCount function. Make it the control source for a text box control.<br>
<br>
The DLookup function is also useful. Use it to get a specific value out of a table.