Report Calculation

[Apache65]

Is there a way to calculate a value from another calculated value on the same report? What I'm trying to accomplish is a report footer average calculated from a detail footer average. Please see my attached report detail screen.

I want value #4 to be an average of #3, but it's actually an average of #1’s on the report. Any ideas??? Thanks…………………

 

[dhookom]

Two major problems:
[ol] [li]this is an Access Forms forum, not reports[/li]
[li]you can't expect anyone to see your image when it's on your hard drive[/li][/ol]


Post to the Reports forum and explain the problem the best you can providing calculations and report sections.

Duane
Hook'D on Access
MS Access MVP