Grand total in report footer?

[Rose]

In doing a report, can you perform a grand subtotal of records by a category?

For example if you have 50 records of people who served in the military and
1 field categorizes them by Soldier, Sailor, Marine or Airmen (But you do not
want to sort by this field). Can a grand total be created in the report
footer that shows me how many are in each category?

 

[Allen Browne]

So you want to provide *another* summary of the data at the end of the
report?

Use a subreport in the Report Footer section. The subreport's Record Source
will be a query that groups and counts as desired.

It's all very straight forward unless you will be filtering the main report.
If so, the problem is to filter the subreport the same way. Simplest
solution is to use a form where the user enters the limiting criteria in
text boxes, and to refer to those text boxes in both queries (i.e. the main
report's query and the subreport's query.)

 

[Rose]

Many Thanks, it worked.
--
Rose

So you want to provide *another* summary of the data at the end of the
report?

Use a subreport in the Report Footer section. The subreport's Record Source
will be a query that groups and counts as desired.

It's all very straight forward unless you will be filtering the main report.
If so, the problem is to filter the subreport the same way. Simplest
solution is to use a form where the user enters the limiting criteria in
text boxes, and to refer to those text boxes in both queries (i.e. the main
report's query and the subreport's query.)