 |
Create a Select query with tables containing the records you want
to
update. Click here:
 if you don't know how to do this. Use the Back button on your Browser to return here when you're through. |
|
Display this query in Design view. Click here:
if you don't know how to do this. Use the Back button on your Browser to return here when you're through. |
|
Click the arrow next to the  button and then click Update Query on the list. |
||
|
For each table containing records you want to update, drag fields from the Field list into the grid. |
||
|
If you want, enter criteria. Click here:
if you don't know how to do this. Use the Back button on your Browser to return here when you're through. |
||
|
If you want, click the View button to
preview the records that will be updated. Click the View button again to return. |
||
|
To run the query:
|
button.