Rounding in Access Reports
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.
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?