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.
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.
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.