How do you calculate tax using a query in Microsoft access?

The easiest way to do this, assuming you have a fixed tax rate, is to simple create a calculated field in a query.

Let's say you have a table with Price, Quantity, and TaxRate in it. Create a query based on that table, and bring these three fields into the query.

Now create a new, calculated query in a new column. In the first row (the name) of the query, put the following:

SalesTax: (Price * Quantity) * TaxRate

When you run the query, you should see SalesTaxt as a new, calculated field. Now you can use this query for any forms or reports you need this value in.

Hope this helps.

Richard Rost

www.AccessLearningZone.com