Stated problem: totals are wrong in print preview. Suggestion: always use print preview. Am I misinterpreting something
Where/how are the calculations being performed? Group header/footer in code? Group header/footer on report? Section header?
What about the other report columns; do they calculate correctly?
Are you switching views and causing the problem (indicates calculations being repeated by code) or does it also fail if you open in print preview only?
Does it calculate correctly if printed?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.