Calculate percentages for groups and subgroups

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

Guest

I am using Access 2002. I have a report that contains two groupings and I am
having the report sum the number of items in the both the major group and the
subgroups within the major group. I would like the report to calculate and
show for each subgroup the percentage that is represented by the total number
of items in the subgroup divided by the total number of items in the major
group.

Is there a way to do this in the design of the Report? Or must I set up a
query to count the fields to which the groupings apply and then have the
query calculate a percentage?
 
QuovadisTexas said:
I am using Access 2002. I have a report that contains two groupings and I am
having the report sum the number of items in the both the major group and the
subgroups within the major group. I would like the report to calculate and
show for each subgroup the percentage that is represented by the total number
of items in the subgroup divided by the total number of items in the major
group.

Is there a way to do this in the design of the Report? Or must I set up a
query to count the fields to which the groupings apply and then have the
query calculate a percentage?
Click to expand...

Add a text box to the major group header section that sums
its total, then use that text box as the divisor in the
minor group footer text box's calculation.
 
Back
Top