Running sum in report page footer gives wrong subtotals?

[Bertje]

Hi,

I try to add running sums in the page footer of my Access reports, defined a
variable in the detail section which nicely adds up values (using the
"OnPrint" event). Then I print this variable in the page footer.

But I get the following arbitrary error. On some pages the page footer gives
the right sum, but on other pages the page sum adds value of the first record
of the next page. As if by the time the variable is printed in the page
footer, the variable is already incremented with the first record on the next
page.

Is this a known issue? Who has a solution?

Thanks!

 

[fredg]

Hi,

I try to add running sums in the page footer of my Access reports, defined a
variable in the detail section which nicely adds up values (using the
"OnPrint" event). Then I print this variable in the page footer.

But I get the following arbitrary error. On some pages the page footer gives
the right sum, but on other pages the page sum adds value of the first record
of the next page. As if by the time the variable is printed in the page
footer, the variable is already incremented with the first record on the next
page.

Is this a known issue? Who has a solution?

Thanks!

See the Microsoft KnowledgeBase article:
132017 "How to sum a column of numbers in a report by page"