Full Version: outside query
UtterAccess Discussion Forums > Microsoft® Access > Access Reports
1MikeF
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?
HiTechCoach
You could add a sub report that show the count or use a text box with the control source using DCOUNT()
1MikeF
Thanks for the assistance. It turns out that I asked the wrong question.
That I meant to ask was how to get the sum of a specific calculated field (all integers) in all of the returned records.
For example:
qry "B" returns 3 records that look like this:
Name Count
Jim 2
Bill 3
Boyd 5
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?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.