2% increase

[expublish]

I have a table with a currency field. There are lots of records, each with a salary in the currency field.

What I need to do is increase the salary in each record by 2% - i.e. an annual salary increase (bloody tight!).

This is a one off thing, so I am guessing some sort of update query. Anyone point me in the right direction?

Thanks.

 

[Ally]

Sounds like the NHS with their salary increases!

What about an update query with

[YourSalaryField]*1.02

Percentages aren't my strong point, but I believe that multiplying by 1.02 is the same as doing it the long winded way around:

[YourSalaryField]*(2/100) and adding the result on to the field.

I did just test it on a temporary table and it appeared to work.

 

[expublish]

Worked - thanks.

By the way ... I work for a charity - probably worse than the NHS!