Microsoft Access - Help required

[Pettsi]

Hi, i am doing a access project for my A level coursework, and have come to a sticky situation...

I am using Maplins as my client.. The system i am creating is a ordering system... I need to use 2 fields on the 'stock table' for the price...

'Price exc. VAT' & 'Price inc. VAT'....

How can i get the system to add 17.5% VAT onto the price, and put that price into the Price inc. VAT??

I have tried, but failed....

If that makes sense, can anyone help?

Many Thanks

Matt

 

[RSi Dave]

You using Forms?

If so you need to build an Expression...

Have two text boxes on your form, Text0 should display the data from coloum 1 in table 1. On the second text box enter the following expression in the control source section inside the text box properties.

=[Text0]*1.175

change Text0 to the name of the text box.

This will add 17.5% to any value from Column 1 in table 1

 

[Pettsi]

Brilliant! thankyou so much! it was getting on my nerves! i just could not do it! i owe u one! cheers mate!