Help!! Totalling Results from "Count" function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Use a totals query as the record source for a subreport that you place in
the report footer.
 
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.
 
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.
 
Back
Top