How to prevent totals from doubling in printed report

[Goldar]

I accumulate some totals in the Detail format event. WHen I vies the report,
these totals are correct, but when I print the report, they are doubled. I
now know when printing, Access processes the report twice. Since all of my
reports must be able to be viewed as well as printed, how can I use VBA code
to skip the accumulation on either the first or the second pass? Also, how
can I determine if the report is being Viewed or Printed?

Thanks,

 

[Steve]

Rather than using code to get your totals, look at using the Sum function or
the running sum feature in your report.

Steve
[email protected]