Taxable vs non taxable Items/Orders

[ponzi99]

Hello I am new to Access has been spending some time learning to build A database for my Small Business, i have some customers who are Tax exempt as well as some line items such as labor of which are not taxed in my state.
I Have built my form but as of right now I am using a math operator to calculate tax (Subtotal*.08625) But in order for me to properly calculate tax I need to exclude some line items from a sub total each item has a yes no box on weather it is taxed or not. Assuming I would need to build a Query to add all the items that are marked as taxable. But I am unsure of how I would go about building the query

so under my OrderInvoiceQ I want to find the SUM(ExtPrice) of the that are marked yes taxable with a yes/no Data Type then multiply the SUM by .08625 to get the 8.625% tax that I can add to my Subtotal.

[mike60smart]

In the query Record Soure you would create a new field to gat the Tax Value.

IIf([Taxable]="Yes",00.08625,0)

[ponzi99]

So IIf() acts as an if function? And what your saying is find tax for individual items then add them together?

[mike60smart]

Hi
If you can upload a zipped copy of the database I will give you an example of how to do this.

[Welshgasman]

So IIf() acts as an if function? And what your saying is find tax for individual items then add them together?

IIF() is a function?
So if your item is marked as taxable, then the rate is 0.8625, else it is zero.
That way you can calculate the taxable value and add to net value of item.

[ponzi99]

Hi
If you can upload a zipped copy of the database I will give you an example of how to do this.

If I did it correctly the Data Base should be Attached to this Comment Apologies for the delay

[mike60smart]

Hi

See the modified Db attached

In the Subform of the Form that opens at startup look at the Record Source to see the new field added "TaxRate"