I want to add a text box to my report that will count the total number of records from a table and display that total.
How do I do this?
I want to add a text box to my report that will count the total number of records from a table and display that total.
How do I do this?
Put something like this in the control source: =dcount("*",[YourTableName])
Cheers,
Vlad
Have you checked the spelling of the table name? Can you show a picture with the design view and the properties sheet?
Make sure you put the table name in quotes;
=DCount("*", "YourTable")
Gicu,
I'm unable to share it with you. I really wish I could. Sorry.
Beetle,
I added the quotes around the table name, however, now the error just says "#Error".
I figured out my problem. I needed the quotes but I was referring the column in the table rather than the table itself.
Thanks to both of you!
Glad to hear!