Rounding error

[JoPaBC]

Hi,
I have a rounding problem problem with my report
I tried a plain SUM function, Int((Sum([total])+0.005)*100)/100, Round(Sum([total]),2) but still not getting a proper result in some cases (like 3630.63+419.18+524.37+798.71 showes as 5372.88 instead of 5372.89)
The input data are from an access table in currency format.
Any idea please?

 

[dhookom]

I expect the values you mention are not the full value and include more than 2 decimal places. Access will perform rounding (typically bankers) when displaying fewer decimal places.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[JoPaBC]

Well, it takes values (as currency) from one table,see below

 

[dhookom]

The currency field in Access stores up to 4 decimal places. View your data with all 4 decimal places displayed. Either that or copy the data and paste into Excel for review.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[JoPaBC]

Oh, thanks, I didn't know that.