Hi Lea, There are two ways to do this, either through a query or using the
controls on the form.
Query first. Pull through the data you require via a query, including
'invoice amount', create a new column in the query by typing in the
following
- Invoice_VAT: Round([invoice amount]/1.175*0.175,2)
In another column type in Invoice_Total: Round([invoice_amount]/1.175,2)
You can then use these fields on your form.
On a form ensure the invoice amount field is on the form and has a
datasource of invoice amount and a name of invoice amount.
Create a new control and name it as Invoice_Total. In the datasource type
in
=Round([invoice amount]/1.175,2)
Create the next control and name it Invoice_VAT. In the datasource type in
=[invoice amount]-Invoice_Total
If you can, I recommend you avoid using spaces in field and control names.
Also, under VAT regulations, VAT is actually calculated and rounded on
each
invoice line. Consequently the above may not give quite the same answer if
comparing with a supplier invoice for example since you are rounding a
potentially larger number.
Hope this helps
regards
Ptero
Lea said:
I have an "invoice amount" field on a form and need to get it to
calculate
VAT (17.5%) into the "invoice VAT" field and then show the total of both
fields in the "invoice total" field. I created the form from a table if
that
helps or hinders! All calculations need to be to 2 decimal places. I've
looked at help but I'm more confused now than ever.
Thanks