Hello, I'm wondering how to incorporate multiple tax levels on items. I have to deal with a State and County tax here and I noticed that if I take an item priced at $15.00 and multiplying it * .055 using the round function the total price comes to $15.82. However if I do it by using the round function multiplying the price by .05 and then the price by.005 and adding all three together the total comes to $15.83. I need to report both state and county tax separately. I'm just trying to figure out how to implement it in the database being built over the course of the lessons.
Thanks for your time, Brad
Bradley NeumannOP
@Reply 14 months ago
I also noticed something about the printable invoice report. The LineItemTotals include sales tax. The sales tax total is listed separately. but the order total is the sum of the line totals. I think I have figured out a way to do the State tax by using SalesTaxRate at 5.0% and the then defining SalesTaxRate2 an .5% with the same calculations/formulas, but Is there a way that I can not include the tax in the in the line item totals yet still calculate the two tax levels for each item in a hidden field on the form and then sum each tax level and put in on the the invoice as:
Subtotal Of Items: $X.XX
State Tax: $X.XX
County Tax: $X.XX
Grand Total: $X.XX
I'm sure I could do it bumming and multiply by the respective tax rates, but I think thing s get messed up when something is non taxable.
I just want to make easy for the customer to understand and to have accurate totals for my books.
Thank You,
Brad
Bradley NeumannOP
@Reply 14 months ago
Forgive my typos that I just notices please. My fingers aren't keeping up with my brain
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
Access Expert 9.
