Modifying a price data column by a factor

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would appreciate your help in programming an Access table so I can multiply
a column of price values by a factor and copying it in place of the original
column.
 
I would appreciate your help in programming an Access table so I can multiply
a column of price values by a factor and copying it in place of the original
column.

To permanently change the value of each record in the table use an
Update query.
To increase the value by let's say 15%:

Update YourTable Set YourTable.[PriceField] = [PriceField]*1.15;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top