report rounding problem in sum

D

dp

Hi Guys,

I am having a crazy rounding problem in access reports. On the bottom
footer of my report I have summed all amounts:
sum([amount]) and set the format as currency.
However, when I add all the amounts up by hand the sum is more than the sum
in access.
When I export the report to excel, the same thing, the sum is more.
I have tried using round(amount,4) and various other methods, does anyone
have any suggestions.

thanks,
dp
 
Top