Calculations in tables

C

Chuckie1471

I am trying to create a table where the VAT Total and Overall Total are
calculated. The VAT calculation uses the Subtotal found in a lookup list
within the table and the Total field uses the calculated VAT Total and the
Subtotal. Is there any way this will work without having to close the table
after the VAT is calculated and then reopen it for it to calculate the total?
 
L

lljo40

Don't do it in a Table!

Use a query, that's part of the power available there. You should NEVER
(well almost never) store a calculated value in a table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

historic VAT Rate lookup 10
i need help..on sub totals! 3
VAT on Report 5
Calculations in Tables 4
Access 2003 4
Using the result of a calculated field in another calculated field's expression 1
Add and show vat to an exisiting amount and show total 16
Dumb question alert! What program to use? 0

Top