Average of a calculated value displayed on all reports 1

[Ataraxia]

Hi

I need to produce a multiple page report which displays a different person's test results on each page. I have a field which displays the person's highest test result as a percentage and I want to display an average of all participant's test results along with the individuals.

I understand that calculations for all reports can be carried out in the report footer but I am experiencing difficulty referring to the percentage field here.

Please let me know if you need further information in order to help.

Many many thanks

 

[CosmoKramer]

It sounds like you are trying to refer to the calculated control in the report footer. Unfortunately, Access won't let you do that, you will have to re-calculate the average in the report footer, using the original fields, something like this:

=Sum([Field1] / [Field2])

or

=Sum([Field1]) / Sum([Field2])

 

[Ataraxia]

Thanks a lot CosmoKramer. Managed to get it done sorted now.