Sep 19 2005, 10:30 PM
I have a report that is based on query “A.” I want to have a text box on this report that will show the count of records returned for query “B.” How can I do this?
Sep 19 2005, 10:43 PM
You could add a sub report that show the count or use a text box with the control source using DCOUNT()
Sep 22 2005, 07:41 AM
Thanks for the assistance. It turns out that I asked the wrong question.
What I meant to ask was how to get the sum of a specific calculated field (all integers) in all of the returned records.
qry "B" returns 3 records that look like this:
I want to have a text box on a report that is based on query "A" show the SUM (in this case - 10) of the Count field from query "B".
Relatedly, when putting a text box on a report, can I make the control source related to an “on-the-fly” query that is not saved anywhere else?