update query to add percentage and round

[achisholm]

Hello, i am trying to write an update query that will take [product].[price] (a number like 27600)

and add 10% to it (30360),

then round this number to the nearest 100 (30400)

any help is greatly appreciated.

 

[aleb]

Yournewfield: Round(([Youramountfield]*1.1)/100)*100