Adding Tax to a total

[Nick Druce]

I have created a database that calculates a total for a week or month depending on what the customer wants.

How do I calculate the Tax it?

I have attached the Databases in case it helps


Any help would be great.

 

[astarbyfar]

Tax calculation

Im not sure why but many experts on this forum dont believe in storing a calculated expression in a table. Hence in the form type the following into the Control source of a text box which we will call Total cost including tax;

=[Original cost without tax * 0.17]+[Original cost without tax]

In this case I have used the tax as 17% however simply alter this to the required rate. Hope this helps

Mike

 

[Oldsoftboss]

Add a field to your table called TaxRate. Set it's default value to 17. Add this field to your form.

When a new record is added, the default value will be displayed. Then the calculated field would be:

=([Original cost without tax] * ([TaxRate]/100))+[Original cost without tax]

This way if the tax rate changes, or you ship to a state or country that has a different rate, it will be easier to change.

Dave

 

[Nick Druce]

thanks

Many thanks to you both for that