Display a count of field not in query

[RenaG]

I have created a report to display data from surveys. The report shows the location the survey was taken and then (by location) the count for every program wanted.

I have attached a screen print. What I am trying to do is put the 'Total number of surveys received:' on the report for each location. The figure shown is incorrect. I just put something there to show you what I am trying to accomplish.

I hope this is enough information to go on. Any suggestions on how to get this number and display it on the report?

TIA!

 

[RenaG]

I came up with a solution that works. I used a subreport. I created a query to count the surveys by location. Then I added a subreport based on the new query. I had to fiddle with it a bit to make it look the way I wanted but I am pleased with the results.

A screen print is attached in case anybody wanted to look at it.

If anybody has a better solution, I am open to suggestions. Always glad to learn new things!