How do you take a known dollar value (totalcost) such as $240.00, back out the sales taxes from the known values using the States (VA and WV) sales tax, showing the difference so that You can print an invoice, with the fields Customer name, address, city, state Subtotal, sales tax and totalcost $240.00. All fields are currently within one table which you have built currently using table in Mysql and OpenOffice Base.
These are all the fields you have in your database which are currently created in an Open Office Base and MySql Table. You would prefer to use MySQL. Virginia (VA) Sales tax is 5.3 percent and West Virginia's is 6.5 percent.
CustomerID
OldAcctID
FirstName
LastName
City
State
ZipCode
TotalCost (known) 240.00
TaxRate (VA) and (WV)
You need to create an invoice such as:
Name: First and Last Name Square Foot: 2000 Price: Value prior to Sales taxamount
Address: xxxx Any Street Sales Tax: 0.xx
City, State Zip CodeTotal Cost: $240.00 (example)