Update query

[Craig4646]

Hi,

I am trying to create an update query where i would like to increase a percentage of all stock items that are stored on the database, for example increasing the price by 10%

I have tried under the unit price field under update to entering [UnitPrice]+10 and this only increase the price by 10 and not 10%

Does anyone know how this can be done? what do i need to change i have tried att a % and it does not, tried *0.10 and does work any ideas? and yes i am very new to access!!!

Thanks in advance

Craig

 

[pbaldy]

How about

[UnitPrice] * 1.1

 

[trucktime]

Increase

How about:

[Unitprice]*1.10

 

[Craig4646]

Thanks that seems to work perfectly!

Just out of interest why is it *1.1???

thanks

Craig

 

[RV]

Just out of interest why is it *1.1???

Well, that's what's called basic mathematics

RV

 

[pbaldy]

Simple math. You said you wanted to add 10%. Your formula of

[UnitPrice]+10%

was wrong because Access didn't know what you meant, and it doesn't assume. 10% of what? It would have to have been

[UnitPrice] + ([UnitPrice]*.1)

which can be reduced to

[UnitPrice] * 1.1