Apache65
Technical User
- Jan 30, 2006
- 16
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. Below is the report detail screen.
Report Header
Report Title
---------------------------------------------------------
Page Header
Pname WoundID Healing Rate
---------------------------------------------------------
Wound_Doc Header
[Wound_Doc]
---------------------------------------------------------
Lname Header
=[LName] & ", " & [fname]
---------------------------------------------------------
WoundID Header
[WoundID]
---------------------------------------------------------
Detail
[HealingRate]
---------------------------------------------------------
LName Footer
=Avg([HealingRate])
---------------------------------------------------------
Wound_Doc Footer
=Avg([HealingRate])
---------------------------------------------------------
Page Footer
[=Now()]
----------------------------------------------------------
Report Footer
=Avg([HealingRate])
----------------------------------------------------------
I want my "Report Footer" value to be an average of "Wound_Doc Footer" but it's actually an average of all the "Detail" values on the report. Any ideas??? Thanks.....................
Report Header
Report Title
---------------------------------------------------------
Page Header
Pname WoundID Healing Rate
---------------------------------------------------------
Wound_Doc Header
[Wound_Doc]
---------------------------------------------------------
Lname Header
=[LName] & ", " & [fname]
---------------------------------------------------------
WoundID Header
[WoundID]
---------------------------------------------------------
Detail
[HealingRate]
---------------------------------------------------------
LName Footer
=Avg([HealingRate])
---------------------------------------------------------
Wound_Doc Footer
=Avg([HealingRate])
---------------------------------------------------------
Page Footer
[=Now()]
----------------------------------------------------------
Report Footer
=Avg([HealingRate])
----------------------------------------------------------
I want my "Report Footer" value to be an average of "Wound_Doc Footer" but it's actually an average of all the "Detail" values on the report. Any ideas??? Thanks.....................