Correct in Access, mysterious calculation when printed

[janfolmer]

Hi There,

I have one Access Report, that calculates the totals on bonuses and places that on top of the report. See sample Attachment

Now, when I run the Report, nothing is wrong, it shows me the right number.
As soon as I print it, is shows me an incorrect (most of the time double) and mysterious figure.

How is this possible, and more important, how can I solve this?
Thanks.

 

[Rich]

You're code is in the wrong event, try moving it to the OnPrint

 

[janfolmer]

Ok, everything, that is, the whole event, is moved to OnPrint.
Now it's printing correctly, but it only takes the totals of the first page of the report. So that code is working, only...

How can I get it to a total for all the pages?

 

[janfolmer]

Ok, I moved it (the whole event) to OnPrint. It's working now, partially, as now the totals of just the first page (of a 3 paged report) are summed up. How can I include the other pages into the total in the report header?

 

[janfolmer]

Just saw that I posted the comment twice, sorry

 

[Rickster57]

Reports

Put the following code in the Shop_ID Header On Print Event and see if that gives you some lovin'

gSumBonusTotal = 0