Creates an update query that changes values in fields in a specified table based on specified criteria.
UPDATE table
SET newvalue
WHERE criteria;
The UPDATE statement has these parts:
| Part | Description |
|---|---|
| table | The name of the table containing the data you want to modify. |
| newvalue | An expression that determines the value to be inserted into a particular field in the updated records. |
| criteria | An expression that determines which records will be updated. Only records that satisfy the expression are updated. |
UPDATE is especially useful when you want to change many records or when the records that you want to change are in multiple tables.
You can change several fields at the same time. The following example increases the Order Amount values by 10 percent and the Freight values by 3 percent for shippers in the United Kingdom:
UPDATE Orders
SET OrderAmount = OrderAmount * 1.1,
Freight = Freight * 1.03
WHERE ShipCountry = 'UK';
Important
| SELECT Statement (Microsoft Jet SQL) | WHERE Clause (Microsoft Jet SQL) |