The nitrogen in our DNA, the calcium in our teeth, the iron in our blood, the carbon in our apple pies were made in the interiors of collapsing stars. We are made of starstuff.
I would like to see a video on applying Sales tax for four types of invoice orders ie Taxable order, Taxable Web Order, Non-Taxable Web Order and Resale Order where the sales tax occasionally changes almost annually.
Sandra Truax
@Reply 7 months ago
Expert Level 9 covers something similar to this:
Next, you will learn how to set up a similar relationship to calculate sales tax. Each customer can have their own sales tax rate (some are tax exempt, others out of the state, etc.). Each order can have its own sales tax rate based on the customer. This will set the sales tax for the line items. We'll also set up a system default values table so we can set the default sales tax rate for new customers.
To add another level of complexity, some products are taxable (computers) while others are not (a gallon of milk). We need to make our database smart enough to realize when to not calculate sales tax based on the product selected. You'll also learn about SQL ALIASes, and how to use the IIF function to display a "T" for taxable in the product combo box.
Thanks Sandra!
I reviewed Access Expert 8 and 9 but want to apply the sales tax to the individual invoice order type and need help with that.
Our product table is set up with to reflect if the item is taxable or not with the True/False box.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Survey 2025.
