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

[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!

 

[Duane Hookom]

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.

 

[Guest]

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!