Calculating Data in a field

[Tray]

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?

 

[Bill Edwards]

Yes, there is a way to do this. However, you should not be storing
calculated values in the table. This violates the rules of normalization.
If you want to view the results of calculations then create a query to
perform the calculations on the fly based on values that were stored.