G
Guest
I have 2 fields - a subtotal and a total. To get the total, I want Access to
times the subtotal by 1.1 (to add on 10% tax). I have created a form for
users to input the details. I tried putting the following expression in the
Total box:
=[SubTotal]*1.1
When I input a figure into the Subtotal field, the correct Total amount is
calculated and shown on the form. However, it is not saved in the Total field
of the underlying table. Is there a way to do this?
times the subtotal by 1.1 (to add on 10% tax). I have created a form for
users to input the details. I tried putting the following expression in the
Total box:
=[SubTotal]*1.1
When I input a figure into the Subtotal field, the correct Total amount is
calculated and shown on the form. However, it is not saved in the Total field
of the underlying table. Is there a way to do this?