Member Avatar

MarcusMaximus

i have an access report with two sub reports. A text box in the main report adds 2 values in both sub reports together.

One value is 10.22 and the other is 13.08 which should amount to 23.30 but the value is coming out at 23.29 which is off by one cent.

i have all text boxes set as currency and decimal places set to auto, i have tried setting the decimal places to 3 and it didn't work and also tried round([txtbox1],3) to no avail.

Any help greatly appreciated

round the sub totals to two(2) decimal places
the totals are 10.216 and 13.077 (or similar) displayed to two decimal places

round(10.216+13.076,2) = 23.29
round(10.216,2) + round(13.077,2) = 23.30

Member Avatar

MarcusMaximus

Thanks sorted the proble. :) :)
Is there anyway to make the thread as solved

Member Avatar

MarcusMaximus

Found it :)