I have a standard report that sums invoice totals in a query, grouping by date.

The underlying table stores the data as currency (2dp).

But, when the report is run I get slight rounding errors.

Any ideas?

PS: When I've checked the table data by playing around with the format and I see that some values are stored as long decimals. Is this the problem, should I round the values on saving to the table?

many thanks

Hi
Try rounding in query

Round(Quantity*Unit Price,2)

-vemaju