How to prevent totals from doubling in printed report

  • Thread starter Thread starter Goldar
  • Start date Start date
G

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,
 
Rather than using code to get your totals, look at using the Sum function or
the running sum feature in your report.

Steve
(e-mail address removed)
 
Back
Top