Calculated tax percent keeps repeating same tax in each record.

[Gotoknow]

HI,

Calculated tax percent is working and gives me the right amount of tax but
it keeps repeating the same amount of tax in each new record. The same tax
amount shows up even though I have not yet entered the original cost. I used
for the Tax field =Sum([Original Cost] *.051)

 

[Allen Browne]

Create a query.

In query design, type an expression like this into the Field row:
Tax: [Original Cost] * 0.051

You should now be able to sum this Tax field with a text box in the Form
Footer section of your form.