Running Avg.

[ZigZagZak]

Ok I posted this question once before but got nowhere fast.

I have a sub-report with some hidden formulas. One textbox is just counts
the #of values on the subreport using a running sum starting with 1. Another
is the running sum of minutes that a operation took. I am using these (2)
textboxes to run an average of the operation time. the average is calculated
in a 3rd textbox on the sub-report with the simple formula of :

operationtime/autonumber (from my formula not a actual autonumber)

This gives me accumilative average from item to item listed, (this is
hidden). All fine and dandy. Now I also want to put a textbox in the main
reports page
footer that will give me the value of the accumilated average at the
end of each page of the report.

Problem I am having is when I put that textbox in the footer section its
taking the value for the first average of the next page. Why isn't it
looking to the last one of the page its on?

Thanks in advance

Zach

 

[Maverick]

You should perform these calculations in a query and then base the textbox on
the calculation from the query.