Group Report total problem

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

Guest

I'm trying to sum an amount in a group footer on a report from a query. When
I change from 4 decimal places to 2, it rounds. Clearly you can see the
total is off by .01. Please HELP!
 
You need to round the source data - not merely the total - to get an
accurate sum.

If the source is a calculated field in a query, use Round() in the
expression there.

If the source data is a table field, you need to round the data before it is
stored. Trace where the data is being calculated, and perform the rounding
there. For existing data, use an Update query to round the field.
 
Back
Top