Calculating Average on Subtotals in Report

[Londa1130]

I have a report where I want to calculate the average number appointments. I first count each record in the report based on the person the appointment was scheduled with "Total Number of Appointments" and that value was placed in an unbound control on in the Page Footer section of the report. When I go to calculate the avergage on the "Total Number of Appointments" I get an error. Can anyone please help?

 

[dhookom]

Add a text box in the Person Group Footer (or Header):

Name: txtPersons
Control Source: =1
Running Sum: Over All
Visible: No

In the report footer, add a text box:
Name:txtAvg
Control Source: =Count(*)/txtPersons

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[Londa1130]

I tried using creating the unbound txt in the report footer and entering control source = 1 but it didn't work. I have the one unbound text that's counting the appointments in the each group. I can only select a field from the record instead of entering 1 in control source.

 

[dhookom]

I don't recall suggesting you "creating the unbound txt in the report footer and entering control source = 1". The first text box I suggested adding is in the "Person Group Footer (or Header)". Also, there is not an issue with setting a control source to =1. Don't forget the "=".

Duane
MS Access MVP
Find out how to get great answers faq219-2884.