Adding VAT

[Wev]

Hi all
I am new to Access and am trying to create a table and form for costing
parts.
Could someone tell me how to automatically add 17.5% VAT to a price in
another field.
TIA
Wev

 

[chas]

Hi Wev,

Do you need to store this information permanently or
calculate it when you need it? The second option is
preferable - why store when you can calculate when needed.

You can use the following calculations in the
controlsource of unbound textboxes (or in a query without
the =).

To calculate the VAT amount -
=[ValueField]*0.175

To calculate including VAT -
=[ValueField] + [ValueField]*0.175

hth

chas