Calculated fields in tables (1 Viewer)

[YNWA]

Hi,

I am using calculated field as a data type in access 2010.

They are working fine.

However, I added a new field and now the final calc won't work.

I have Subtoal adding loads of fields together. Works fine.
Then I have a VATunit field which is a double integer, so enter 20 and my next field is VATTotal calculates the SubTotal + the VATunit by doing (Subtotal/100)*VATunit. This calculation is fine and gives me the correct amount.

The next field is a Total field. Which adds Subtotal and the VATTotal together. Howver, the Total is the same as Subtotal. It is not adding the VATTotal to it?

Any ideas?

 

[KenHigg]

You may have to put all your original calculations in the Total field and not base it on previous calculations.

 

[YNWA]

Would that be all fields added together along with the vat field?