Use expressions such as the following in the Update To cell in the query design grid for the field you want to update.
| Expression | Result |
|---|---|
| "Salesperson" | Changes a text value to Salesperson |
| #8/10/99# | Changes a date value to 10-Aug-99 |
| Yes | Changes a No value in a Yes/No field to Yes |
| "PN" & [PartNumber] | Adds PN to the beginning of each specified part number |
| [UnitPrice] * [Quantity] | Calculates the product of UnitPrice and Quantity |
| [Freight] * 1.5 | Increases freight charges by 50 percent |
| DSum("[Quantity] * [UnitPrice]", "Order Details", "[ProductID]=" & [ProductID]) |
Where the Product IDs in the current table match the Product IDs in the Order Details table, updates sales totals based on the product of Quantity and UnitPrice |
| Right([ShipPostalCode], 5) | Truncates the leftmost characters, leaving the five rightmost characters |
| IIf(IsNull([UnitPrice]), 0, [UnitPrice]) | Changes a Null value to a zero (0) in the UnitPrice field |