I have a field named cost and I need to increase it by 15%, how do I enter
that expression in a query?
Back up your table first.
Every Cost item in the table?
Create a new query.
From the Show table dialog box, select the table you wish to update.
Drag the Cost field onto the lower grid.
Then click on Query + Update Query.
In the Update To: row of the Cost column, write:
[Cost] * 1.15
The Query in SQL view would look something like this:
Update YourTable Set YourTable.Cost = Cost * 1.15;