Adding 15% increase to all values

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
[email protected]

"...Man, I ain't changed, but I know I ain't the same..." by The
Wallflowers - One Headlight
 
C

Cheryl Fischer

You can do this with an Update Query, some like the following:

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


hth,
 
Top