Need help with Update Query

[starswinger007]

I know this is probably as simple as can be, but its just not coming to me.



I have to decrease the Prices by 2%. What expression do I need to put in [Price]- ?

There is not percent symbol and when I type it in I get errors.

[matthewspatrick]

Decreasing something by 2% is the same as multiplying by 98%. Something like this should work:

UPDATE MyTable
SET MyField = [MyField] * 0.98

Replace the table and field names to match what you have in your db.