Calculating percentage from grouped report

[Leanne]

My report shows jobs attended grouped by the engineer who went. My report has
parameter values so i can search between the dates i want. From this i would
like in the group footer to be able to calculate what percentage of the total
records shown in the report were completed by each engineer.

I want to be able to divide the total records by the total records in the
group

any help will be much appreciated

 

[Marshall Barton]

My report shows jobs attended grouped by the engineer who went. My report has
parameter values so i can search between the dates i want. From this i would
like in the group footer to be able to calculate what percentage of the total
records shown in the report were completed by each engineer.

I want to be able to divide the total records by the total records in the
group

To use the grand total for the whole report, put a text box
(named txtgrandTotal) in the report's header section and set
its expression to =Count(*)

If you have no other reason to use the report header
section, make it invisible.

Then your group footer text box can display the percentage
by using the expression =Count(*) / txtgrandTotal

 

[Leanne]

Thank you for that.

Do you know how i could use this percentage that is calculated to create a
pie chart?

 

[Marshall Barton]

Do you know how i could use this percentage that is calculated to create a
pie chart?

Best to start a new thread when you have a different
question. I have not had to create a chart in Access in 15
years, so I would just be stumbling around if I tried to
answer it.