Calculating Percent of a Group in Report Footer

  • Thread starter Thread starter h2fcell
  • Start date Start date
H

h2fcell

Using Access 2007, I created a report that uses a query as the Record Source.
By way of a form, I allow the user to select a date range to run the report.
The report Groups data by Company_ID which has a Footer for Totals.
The report also delivers report totals in the Report Footer.

I am drawing a blank on how I would create Company_ID specific percent of
Total in the Report Footer, because the Date range selection always changes
the list of companies and report totals.

Is there a simple way to solve this?
Thanks.
 
h2fcell said:
Using Access 2007, I created a report that uses a query as the Record Source.
By way of a form, I allow the user to select a date range to run the report.
The report Groups data by Company_ID which has a Footer for Totals.
The report also delivers report totals in the Report Footer.

I am drawing a blank on how I would create Company_ID specific percent of
Total in the Report Footer, because the Date range selection always changes
the list of companies and report totals.
Click to expand...


I think this is a good case for a subreport. First create a
Totals type query that uses the same date range parameters
from the form and calculates the aggregates for each
company. Then it can calculates the company percentages
using the grand total in the main report as the divisor.
 
Marshall,
Thank you very much. I created the query and subreport just as you
suggested and it worked like a charm.
 
Back
Top