Do a percent increase on a price column?

[Miracle]

Hi, I have a database of products with prices and would like to do
price adjustment by 5%. I would actually like to raise the prices b
5%. Does anyone know, can this be done with a query or somehow? I did
forum search but didnt find anything.

Thanks in advance for any help!


Chri

 

[Nikos Yannacopoulos]

Chris,

All you need is an update query. From the database window select query
objects view and click on new. Select Design view and add the table that
holds your prices. Double-click on the field that holds the prices to get it
down to the queru design grid. From the menu go Query > Update query. You
will notice that there is now a new line in the grid, labelled Update To. In
that line, underneath the price field, type in:

=[PriceFieldName] * 1.05

(change PriceFieldName to the actual field name). Go back to the menu, Query

Run (or hit the toolbar button with the red exclamation mark).

Your job is done.



HTH,

Nikos