Yearly Average

[Guest]

I have a report that tracks sales totals with the date, month and amount in
the Detail section. I have a yearly total calculated by summing the amount
in the Year Footer. At the bottom of the report I want to have an average
for all years. So for the example below the average at the bottom of the
page would show as 75.

Year 1 100
Year 2 50

The text box that gves the yearly total is named YRLYTOTAL. Thougt I could
just put =AVG([YRLYTOTAL]) in a text box in the report footer, but that
doesn't work.

 

[Jeff Boyce]

When you do this kind of calculation in reports, you have to use the
original fieldname, not an "intermediate" field in which you've done some
other calculations. You'll have to rewrite the (old) calculation within
your new calculation.

Regards

Jeff Boyce
Microsoft Office/Access MVP