Reference no: EM135391

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)