Counting fields outside a query for a Report Total 1

[bethabernathy]

I am trying to set up a report that counts the total number of records in the base table and then also counts the total number of records in the report (which is based on a parameter - date range query). Does anyone know how to do this?

Thanks, Beth Abernathy

 

[Databaseguy]

Look into the help files for the DCount function... Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[bethabernathy]

Hi Tyrone - Awesome!!!! Thanks so much - it worked perfectly. I used the following:

=DCount("[YellowcardID]","tblyellowcard&quot

I am counting the number of "yellow cards" and it pulls the data from the Table "tblyellowcard" rather than from the query on which the data for the report is based.

Thank you soooooooooooooooo much!!

Beth