M marckk Registered User. Local time Today, 10:21 Joined Mar 22, 2012 Messages 18 Mar 26, 2012 #1 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?
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?
pbaldy Wino Moderator Staff member Local time Today, 07:21 Joined Aug 30, 2003 Messages 36,157 Mar 26, 2012 #2 Does this work as the control source of a textbox? =DCount("*", "QueryName")
M marckk Registered User. Local time Today, 10:21 Joined Mar 22, 2012 Messages 18 Mar 26, 2012 #3 pbaldy said: Does this work as the control source of a textbox? =DCount("*", "QueryName") Click to expand... You sir are my IDOL!! thank you very much! Worked perfectly:thumbsup:
pbaldy said: Does this work as the control source of a textbox? =DCount("*", "QueryName") Click to expand... You sir are my IDOL!! thank you very much! Worked perfectly:thumbsup:
pbaldy Wino Moderator Staff member Local time Today, 07:21 Joined Aug 30, 2003 Messages 36,157 Mar 26, 2012 #4 Happy to help!