calculation help

[PPDK9]

I created a 2 page form using tab control...In one of the fields I added the expression =Sum([Amount Quoted]*.06) in order to calculate sales tax. Problem is that when you start a second record the sales tax box contains the calculation from the first record and if you add an amount to the Amount Quoted field of record 2 it changes the sales tax in the first record...it adds the two amount qouted fields and then figures the sales tax.. I am very perplexed HELP!!

Thanks, Peter

 

[KevinM]

Remove Sum and brackets if you want to calculate only the current record....

=[Amount Quoted]*.06

Sum will add all values in the form's recordset

 

[Rob.Mills]

Is this field summing the fields in a subform? If so, I would create the textbox in the subform itself.

 

[PPDK9]

Kevin...thank you for your time...I will try that and let you know how I made out
Peter

 

[PPDK9]

Rob...thank you also...I haven't got that far yet in the design of things but I will use that when I do
Peter