Thank you a bunch, with a little editing it worked perfectly. I had to rethink some of my practices with my database, so that tax is based only off of the ship to field. Otherwise it caused problems and too many if statements.
Once again thank you, your help is greatly appreciated.
CKENT
Last Activity: Jul 24 '14, 10:17 PM
Joined: Feb 2 '09
Location:
-
Ok I am a little confused, and sorry for sounding ignorant but... How would I use that in the VBA code noted above.
The tax table is a completely separate table from the form/table I am using, and it does not have a TaxRate field on the form. It has a "tax" field but it has to show the tax as calculated above. So that it actually shows the tax amount rather than the tax rate.
Nico I see what you are saying,...Leave a comment:
-
Anybody have any ideas on this???Leave a comment:
-
Multiply form field by separate table field.
Ok I have been customizing this DB for a long time. Basically it is an invoice form, so... I have the tax rates hard coded for calculation. My business is in three states, so I have three different tax rates. Here is my VBA code for this section.
...Code:If Me!StateIn = "TN" Or Me!ShiptoState = "TN" Then Me!Tax = (Me!PartTTL + Postage + LaborTTL - Discount) * 0.0975 ElseIf Me!StateIn = "FL"
No activity results to display
Leave a comment: