Is there a way of working out VAT in Access 2003

[Guest]

I am trying to get Access to work out 17.5% VAT, does anyone know how please?

 

[Guest]

Is this on a form?

If so:

In the control source of your text box put:

=[YourTotalField] * 0.175

This gives you how much VAT is to be paid.

=[YourTotalField] * 1.175

This gives you the total including VAT.

Replace [YourTotalField] with the name of the control that shows your total.

Dave

 

[Brendan Reynolds]

Here's an example that uses the Order Details table from the Northwind
sample data base. In order to keep the example simple, I've ignored the
Discount field in the Order Details table, and hard-coded the VAT rate into
the query. In a real-world app, there would likely be a VAT Codes table that
would need to be joined into the query.

SELECT [Order Details].UnitPrice, [Order Details].Quantity,
([UnitPrice]*[Quantity])*0.175 AS VAT
FROM [Order Details];

 

[Jamie Collins]

Here's an example that uses the Order Details table from the Northwind
sample data base.

SELECT [Order Details].UnitPrice, [Order Details].Quantity,
([UnitPrice]*[Quantity])*0.175 AS VAT
FROM [Order Details];

Slightly picky point: I think the data type for VAT should be the same
as for UnitPrice:

SELECT TYPENAME([Order Details].UnitPrice) AS UnitPrice_type,
TYPENAME(([UnitPrice]*[Quantity])*0.175) AS VAT_type
FROM [Order Details];

returns 'Currency' and 'Decimal' ('Double' in Jet 3.n) respectively.

Jamie.

--