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