Does anyone know VAT formula or can tell me where i can find Access/VBA library for VAT formula. In Europe and Canada, they use VATand can be up to 10 VATs.
Let say, given: qty=1, Price=$100.00, Amount= qty * Price = 1 * 100.00, where: " * " means multiplication.
Compute each tax and Total VAT if:
Sales tax=3.00%, Province tax=3.00%, County tax=1.5%, City tax=1.5%, Government tax=2.00%.
Thanks in advance to all..