Help!! Totalling Results from "Count" function

D

dannablum

In my report, I have used the count function, showing a count of employees
within different departments, no problem. However, I need to show, in the
report footer, the total of the results from those counts. How do I do this?
 
D

Duane Hookom

Use a totals query as the record source for a subreport that you place in
the report footer.
 
D

dannablum

Duane:

How, exactly, do I do this? I'm very new at Access. Could you be a bit
more specific about what I should put where?

Thanks so much.
 
D

Duane Hookom

First, create a totals query that is similar to your main report's query. I
expect you would group by department. This query should display the results
you want in your report footer.

Then create a report (subreport) based on your query. You can then add this
"totals" report as a subreport in your main report.
 
Top