Simple Math Not Adding

[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

 

[irish634]

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

TextBox1 + TextBox2 + $0.01
What happens if you set decimals to 2? Try setting the decimals to 2 in the form and table as well. What is the value in the tables? Perhaps your error is not in the report?

 

[SOS]

What is the datatype at the table level. My guess is that you have SINGLE or DOUBLE selected instead of DECIMAL. Change to DECIMAL with a SCALE of 2.

 

[MarcusMaximus]

At Table level its set to currency but ill double check to make sure

 

[SOS]

At Table level its set to currency but ill double check to make sure

Make sure the SCALE is set to 2.

 

[MarcusMaximus]

solved. Thanks for the help.
Used round([textbox],2)