Printing calculations

[olorin]

Hi there,
I have a report that when viewed in ReportView calculates all the txtboxes correct, but when printed, the txtbox calculations are not correct.
txtPallTotal calculates if pkPackagingID is 3;
=IIf([cboPackaging]=3,0,[NumberOfPallets])
which is a running sum over group.
I then have a txtbox called txtTotalPall which is not a running sum placed in the Report footer so as to be the total of cboPackaging.

The more I write this, the more confusing it looks.
Basically, when the report prints, it only prints the first calculation and not the total, but when in ReportView it does the calculations correct.

Hope you can help.

 

[Sum Guy]

Are you doing your calculations in the report itself or in a query?

Try doing your maths in a query, then run the report based on the query.

 

[olorin]

Hmmm.
Never thought of that.
I'll try that later (when I get time, I'm at work), and let you know.
Thanx a lot for the tip

 

[olorin]

Brilliant! Fandabbydozy! works a treat.
Much appreciated