Calculate Sales tax on only taxable items

  • Thread starter Thread starter Russ via AccessMonster.com
  • Start date Start date
R

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
 
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?
 
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
 
Again "What are some field names that we can use? Is there a rate somewhere
that you aren't telling us about?"
 
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?


Duane said:
Again "What are some field names that we can use? Is there a rate somewhere
that you aren't telling us about?"
Hello,
Click to expand...
[quoted text clipped - 16 lines]
Click to expand...
 
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


Russ via AccessMonster.com said:
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?


Duane said:
Again "What are some field names that we can use? Is there a rate
somewhere
that you aren't telling us about?"
Hello,
Click to expand...
[quoted text clipped - 16 lines]
Any suggestions would be great!
Thanks
Click to expand...
Click to expand...
Click to expand...
 
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.


Duane said:
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"
Click to expand...
[quoted text clipped - 12 lines]
Click to expand...
 
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


Russ via AccessMonster.com said:
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.


Duane said:
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"
Click to expand...
[quoted text clipped - 12 lines]
Any suggestions would be great!
Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top