Running sum not correct

[ZigZagZak]

I have a sub-report with some hidden formulas. One is a running sum of #of
minutes that a operation took. The other is primarily a auto number so I can
run an average of the operation time. the average is done in a 3rd textbox
with the simple formula of :

operation/autonumber

This gives me accumilative average from item to item listed (this is also
hidden). All fine and dandy. Now I also want to put a textbox in the page
footer of the main report that will give me the value of the 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?

Can anybody shed some light....pulling my hair out over here!

Thanks in advance

Zach

 

[Jeff Boyce]

Hold on a second...

You mention you have an "auto number". Do you mean you are using an Access
Autonumber field? Are you aware that an Autonumber is NOT guaranteed to be
sequential? An Autonumber is intended to serve as a unique row identifier,
nothing more.

You can't calculate a (guaranteed accurate) average using an Access
Autonumber. Instead, if you want to have an average length of operation per
???, divide by the number of ???s.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Golfinray]

Put it the PAGE footer.

 

[ZigZagZak]

Ok Golfinray. thanks for the reply, however it already is.....which is why I
am puzzeled to why it takes the value from the 1st line of the next page.

Jeff-
I am not using a "access auto number field".
I put a text box on my subreport that has a control source = 1 then made
running sum equal to over all so it would pretty much just counts the records
for me without giving me the total on each line.

 

[Jeff Boyce]

Different experience with the term "autonumber"...

I'm not clear yet where the various pieces of this are located. Are you
trying to do this entirely within a sub-report? Are you doing the
calculation in a sub-report, but trying to show the "running average" in the
main report?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[ZigZagZak]

Hey Jeff-
Sorry for the slow reply, I was on vacation. All the calculations are done
in the detail section of the sub report. Then on the page footer of the main
report I have a textbox which I set equal to the textbox on the subreport.

Like I said before, it calculates correctly & the textbox on the main report
does reference it. But it shows the average including the first line on the
next page, instead of stoping on the page its printed on.

And a "running average" is exactly what I am trying to acomplish but per
printed page not per entry....

Thanks for the patience
Zach

 

[Jeff Boyce]

Zach

Very little experience doing what you're describing.

I'll suggest re-posting to this newsgroup with the kind of description you
just offered ... there's a lot of "report" folks out here!

Good luck!


Regards

Jeff Boyce
Microsoft Office/Access MVP