Adding 15% increase to all values

  • Thread starter Thread starter Sean Burke
  • Start date Start date
S

Sean Burke

I have a table with over 1000 monetary values that I need to increase by
15%. Other than manually caluculating all the new prices, is there a way to
add 15% to the existing field/value?

Thanks for any suggestions.

--
Sean Burke
(e-mail address removed)

"...Man, I ain't changed, but I know I ain't the same..." by The
Wallflowers - One Headlight
 
You can do this with an Update Query, some like the following:

UPDATE [MyTable] SET [MyTable].Amount = [Amount]*1.15


hth,
 
Back
Top