MS Access 97 - I have to calculate 2 tax amounts based on a subtotal amout.
In Query (Total = subtotal + tax 1 + tax 2)
subtotal = 25.3333
tax 1 = 50.333
tax 2 = 25.3333
Total = 100.9996
When I print the individual fields on an invoice or display in a form as 2 decimals, I get
subtotal = 25.33
tax 1 = 50.33
tax 2 = 25.33
Total = 101.00
The 3 detail fields do not add up to the total field.
Is there a (simple) solution to stop the rounding.
I would prefer the detail fields were limitied to 2 decimals
When defining the Table fields -
if I set field to double, the decimal positions is for display purposes only.
Integer does not allow decimals, even though there is no error when you define 2 decimals.
Interger does not allow decimals.
In Query (Total = subtotal + tax 1 + tax 2)
subtotal = 25.3333
tax 1 = 50.333
tax 2 = 25.3333
Total = 100.9996
When I print the individual fields on an invoice or display in a form as 2 decimals, I get
subtotal = 25.33
tax 1 = 50.33
tax 2 = 25.33
Total = 101.00
The 3 detail fields do not add up to the total field.
Is there a (simple) solution to stop the rounding.
I would prefer the detail fields were limitied to 2 decimals
When defining the Table fields -
if I set field to double, the decimal positions is for display purposes only.
Integer does not allow decimals, even though there is no error when you define 2 decimals.
Interger does not allow decimals.