0

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

2
Contributors
3
Replies
4
Views
8 Years
Discussion Span
Last Post by MarcusMaximus
0

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

0

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

0

Found it :)

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.