Calculate Sales tax on only taxable items

[Russ via AccessMonster.com]

How can I Calculate Sales tax on only taxable items, my product tame has a
check box for taxable items?
Any suggestions would be great!
Thanks

 

[Duane Hookom]

What is the context of your question? Is this for a form footer? Do you have
a field in your products table that identifies whether or not an item is
taxable? What are some field names that we can use? Is there a rate
somewhere that you aren't telling us about?

 

[Russ via AccessMonster.com]

Hello,

I have a order form with the details in the subform.
On the order form I sum order subtotal, freight, sales tax and fianally the
order total.
The product table has a check box for taxable items called "taxable"
Thanks for the quick response

 

[Duane Hookom]

Again "What are some field names that we can use? Is there a rate somewhere
that you aren't telling us about?"

 

[Russ via AccessMonster.com]

The product table has a check box for taxable items called "taxable"
The order table has a field called "TaxRate"
The order details table has the fields, "ProductNumber", "UnitPrice", "qty",
"LineTotal" and "Discount"
What other information should I offer, or will this do it?

Again "What are some field names that we can use? Is there a rate somewhere
that you aren't telling us about?"

Hello,

[quoted text clipped - 16 lines]

 

[Duane Hookom]

I would expect the taxable item list to change over time. This suggests the
Taxable value should be saved in the order details table. If the taxrate is
the same for all taxable items, you shouldn't need to save the rate in the
order details.

You can add the Taxable field to the productnumber combo box in the order
details. You can use the after update event of the combo box to set the
taxable value in the order details.

--
Duane Hookom
MS Access MVP

The product table has a check box for taxable items called "taxable"
The order table has a field called "TaxRate"
The order details table has the fields, "ProductNumber", "UnitPrice",
"qty",
"LineTotal" and "Discount"
What other information should I offer, or will this do it?

Again "What are some field names that we can use? Is there a rate
somewhere
that you aren't telling us about?"

Hello,

[quoted text clipped - 16 lines]

Any suggestions would be great!
Thanks

 

[Russ via AccessMonster.com]

Sorry but, Still do not understand, what I need to do to just charge tax on
specific items (this being items marked as taxable in the product table) any
example would be greatly appreciated. I just am not getting it and need help.
I want to sum only taxable items on the Orders form.

I would expect the taxable item list to change over time. This suggests the
Taxable value should be saved in the order details table. If the taxrate is
the same for all taxable items, you shouldn't need to save the rate in the
order details.

You can add the Taxable field to the productnumber combo box in the order
details. You can use the after update event of the combo box to set the
taxable value in the order details.

The product table has a check box for taxable items called "taxable"
The order table has a field called "TaxRate"

[quoted text clipped - 12 lines]

 

[Duane Hookom]

If you are storing the tax rate in a field in your order details table then
your expression for the total tax in the form footer would be something
like:

=Sum(Qty * UnitPrice * TaxRate)

--
Duane Hookom
MS Access MVP

Sorry but, Still do not understand, what I need to do to just charge tax
on
specific items (this being items marked as taxable in the product table)
any
example would be greatly appreciated. I just am not getting it and need
help.
I want to sum only taxable items on the Orders form.

I would expect the taxable item list to change over time. This suggests
the
Taxable value should be saved in the order details table. If the taxrate
is
the same for all taxable items, you shouldn't need to save the rate in the
order details.

You can add the Taxable field to the productnumber combo box in the order
details. You can use the after update event of the combo box to set the
taxable value in the order details.

The product table has a check box for taxable items called "taxable"
The order table has a field called "TaxRate"

[quoted text clipped - 12 lines]

Any suggestions would be great!
Thanks