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
Jump to Postround the sub totals to two(2) decimal places
the totals are 10.216 and 13.077 (or similar) displayed to two decimal placesround(10.216+13.076,2) = 23.29
round(10.216,2) + round(13.077,2) = 23.30
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
Thanks sorted the proble. :) :)
Is there anyway to make the thread as solved
Found it :)
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.