Arithmatic Coding

[saeid naeimi-manesh]

Hi:
I designed the Form in access XP version but I can't relate some fields
together. Ex: I have 18 fields as Amount1 to Amount 18 and want to put the
sum of them in the Subtotal Field, also I want to calculate the tax for
subtotal and write it in Sales Tax field, then add this two field(SubTotal &
Sales tax and put it in the Final Amount field
Please guide me to overcome this problem

Regards,
Saeid
(e-mail address removed)

 

[John Vinson]

Hi:
I designed the Form in access XP version but I can't relate some fields
together. Ex: I have 18 fields as Amount1 to Amount 18 and want to put the
sum of them in the Subtotal Field, also I want to calculate the tax for
subtotal and write it in Sales Tax field, then add this two field(SubTotal &
Sales tax and put it in the Final Amount field
Please guide me to overcome this problem

A Form is a tool to manipulate data in tables. Your Form doesn't
"contain" any data; it's just a window onto the Tables. How is your
Table structures? If it has 18 Amount fields, IT IS NOT PROPERLY
NORMALIZED and you will have no end of problems!

I think you need to get the foundation poured correctly, before you
start putting in stairwells and roof girders... or your whole house
may collapse!