In the page heading, select the drop-down list box, and then select Update Query.
If your query contains one query source, the source is selected as the target source.
-or-
If your query contains more than one query source, the Target Query Source window appears.
On the Target Query Source window, select a source from the sources on the canvas, and then select Add.
Note: If the query contains more than one query source, the query sources that you do not select are removed automatically from the design canvas.
The Conditions section is updated to include the following rows:
- Field
- Table
- Update To
- Criteria
- Or
For the fields that you want to modify, in the Update To cells, create expressions to specify criteria for the record update. Any record that meets the specified criteria will be updated according to the expression. For example, if you want to update Motor records for which the manufacturer is WEST to the manufacturer WEST&LONG, you can create a criteria expression in the Update To cell for the Asset Manufacturer field in the Motor family.
In the page heading, select
A dialog box appears, indicating how many records will be updated by the query.
To perform the update, select Yes.
-or-
To stop the update, select No.
Depending on your selection, the update is performed or stopped.
Note: When you run an Update query that will update a large number of records, an error message may appear. If this occurs, adjust the query criteria to reduce the number of records that will be updated at one time.