Using Access 2010
I am almost done with my orders form but cannot figure out how to apply tax to the retail products. I’ve spent several hours looking for a solution but nothing works. I’m hoping someone here can help guide me.
Here is what I have.
My orders form works with the product table.
The products table has items for both services and retail.
When a product record is created the user must select service or retail.
The orders from has two sub forms, 1) service 2) retail.
Each sub form footer sums the extended price.
The orders footer takes these sum totals and totals them as Service and Retail for the user can see the sub total for each category.
What I want to happen:
Apply sales tax to only the retail product items
Store the sales tax with each retail product on each order to allow for calculations on reporting, historical purposes.
Have the ability to change the sales tax in the future but not have it change history.
How can I accomplish this?
Thanks for your help,
Cindy
I am almost done with my orders form but cannot figure out how to apply tax to the retail products. I’ve spent several hours looking for a solution but nothing works. I’m hoping someone here can help guide me.
Here is what I have.
My orders form works with the product table.
The products table has items for both services and retail.
When a product record is created the user must select service or retail.
The orders from has two sub forms, 1) service 2) retail.
Each sub form footer sums the extended price.
The orders footer takes these sum totals and totals them as Service and Retail for the user can see the sub total for each category.
What I want to happen:
Apply sales tax to only the retail product items
Store the sales tax with each retail product on each order to allow for calculations on reporting, historical purposes.
Have the ability to change the sales tax in the future but not have it change history.
How can I accomplish this?
Thanks for your help,
Cindy
