query total in footer

marckk

Registered User.
Local time
Today, 10:21
Joined
Mar 22, 2012
Messages
18
I have a number of pie charts in a report being fed by a single query. What's the easiest way to have the record count show as a total number in the footer for that query?
 
Does this work as the control source of a textbox?

=DCount("*", "QueryName")
 
Does this work as the control source of a textbox?

=DCount("*", "QueryName")

You sir are my IDOL!!

thank you very much!
Worked perfectly:thumbsup:
 

Users who are viewing this thread

Back
Top Bottom