Group Totals

  • Thread starter Thread starter R Kumana
  • Start date Start date
R

R Kumana

I have a report that groups records according to a type.
there are four types, represented by a text value.

At the end of the grouping level, I want to list the total
number of records of each type.

Totals
Type 1: 6
Type 2: 12
Type 3: 24
Type 4: 9
Total: 51

I can get the final total using "Count" on all the
records, but I can't get the subtotals. How do I do this?
 
I assume you want this in either a report footer or footer after your Type
Footer.
Create a query that groups by Type and counts records. Use this query as the
record source of a subreport. Add the subreport to the footer of your main
report.
 
I created the query and Subreport, but when I view my main
report, the subreport shows a blank space.

?
 
Make sure there are no values in the Link Master/Child properties of the
subreport.
 
Back
Top