Calculation

[mvcmi]

I am working on a database to track all the purchases our department utilizes. I have set up a field that calculates the sales tax for each county and set up a Total field that calculates all the costs associated with the purchase. My dilemma is that some items we purchase do not include sales tax. What can I do to remove the sales tax figure from my total in those situations? Also, the sales tax percentage comes from another database that I created a relationship to the specific city I enter in the purchase database.

HELP!!! Thanks.

Cindy

[LiveOak]

Two things. First Sales Tax can be a calculated field turned on and off by the value in a checkbox field:

Taxable? (number) - format as a checkbox with the value "Yes" or "1"

cSaleTax (calculation, number) = If (Taxable?, Sales Tax, 0)

Second, I would make the Sales Tax a lookup, not just a related field. When (not if) sales tax rates change, you don't want the tax rate on all your previous transactions to change.

-bd