Do a percent increase on a price column?

  • Thread starter Thread starter Miracle
  • Start date Start date
M

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
 
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).
Click to expand...

Your job is done.



HTH,

Nikos
 
Back
Top