Report Preview differs from printed report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Lads

My report is meant to total the fees received at our association over a say
6 month period. The preview works fine, and including exchange rates, seems
to compute it fine.

However when I print the report the total at the end differs greatly,
sometimes its twice the acutal, others a few hundred quid more. Is there a
particular reason for this? I used other computers and printers but no joy.

I also used a running total but the end total was wildly off the mark.

im using 2003

thanks in advance lads
 
Are you using code in the report's events to calculate the total? If so,
the best advice is don't since the event can run multiple times in a report
or may be skipped entirely if you skip pages when you preview the report.
In addition, if you preview the report and then print the report, the
accumulation in code will usually be double the expected amount.

Can you add a control to your report footer and set it to
=Sum([TheField])

IF you are using a calculation then you may need something like:
=Sum([TheFee] * [TheExchangeRate])
 
Back
Top