Decrease all the prices

[mllco]

Hi,

I intend to decrease the prices of all the articles of 5%.

I know that I can change all the prices in the ActinicCatalog.mdb file and in the "Product" table.

My question is: is there a method to change all the prices with only one formula ( like in Excel) ?

Thank you very much,

Bruno

[Penfold]

Hi,

You could use an 'Update Query' in Access and use the following formula in the update to field: -

[Price]*0.95

This will reduce your prices by 5%

[mllco]

Hi,

Thank you very much..... that works

Cheers,

Bruno