Adding 15% increase to all values

[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

 

[Cheryl Fischer]

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

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


hth,