running sum

[Dimitris Nikolakakis]

I have created a report and I want to print in the page header and footer
sums of the detail section.

In the footer I want to print the running sum of the detail section so far
and in the header I want to print the running sum of previous pages.

Thanks in advance
Dimitris Nikolakakis

 

[Nikos Yannacopoulos]

Dimitri,

Assuming the control holding the amount is named Text1, create a second
one next to it in the detail section, with the same Control Source
property, and set its Running Sum property to Over All; this should
display the running sum. I'll assume this is named Text2. When you are
happy that this is working correctly, set its Visible property to No, so
it doesn't show on the report. Then add a text box in each of the page
header and footer sections, and set the Control Source property on both to:
=[Text2]
(or whatever the actual name of the running sum control). This should do it.

HTH,
Nikos

 

[Dimitris Nikolakakis]

I have tried it and the result is...

In the first page the running sum in the footer is OK. In the second page,
the running sum in header is the R.S. of previous page footer plus the first
line of the details.

Thanks in advance

Dimitris

 

[Nikos Yannacopoulos]

Hmm.... I've seen this before, and thought I was doing something wrong!
It seems Access isn't very good at prioritizing events, apparently it
formats the page header after it's done so for the first detail. I'm
afraid I don't have a solution.