Count the number of records that have the same data entered in a f

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

Guest

I need to print a report showing the following:

Name Type Dept Date
Jane H Mktg 3/9/98
Bob H HR 4/8/05
Don S Mktg 5/20/03

Total H 2
Total S 1


I've got the query done and I have it displayed in the report. But how do
you display the Total count at the bottom?

Any help is very appreciated!
 
I would create a totals query that groups by Type and counts names. Use this
as the record source for a subreport. Place the subreport in the footer of
your main report. If you add more Type values, this subreport will
automatically include them.
 
I had to figure out how to do the Count aggregation and how to do subreports.
But thanks to your reply I was able to get it to work! Thanks!
 
Back
Top