How to Update a Query in Access Using Another Table
Microsoft Access uses queries to create tables, calculate data and create reports with ease. With Access, users can update queries so that information is pulled from more than one table. When Access uses information from more than one table, the table types and destination fields must be compatible or match. If the data does not match but is compatible, some information may be deleted.
Other People Are Reading
Instructions
-
-
1
Open the Access database that you are using. Click the "Create" tab and find the "Other" section. Select "Query Design" from the available options.
-
2
Click "Table" in the "Show Table" window. The selection window will open. Hold down the "Ctrl" key and select the tables that you are going to pull data from. Select "Add" and hit the "Close" button. The tables will open in the "Design Query" window.
-
-
3
Drag the matching or compatible fields from the second table to the first table. Locate the "Design" tab on the ribbon at the top of the screen. Select "Update" in the "Query Type" section. Double-click all the fields that need to be updated. To add all the fields to the list, double-click the asterisk (*) at the top of the fields list. The fields that where selected will appear in the "Query Design Grid" in the "Field" group. Verify that all the fields you need updated are in the list. If a field is in the list that does not need to be there, highlight the field name in the list and hit the "Delete" key.
-
4
Name the table and field in the first table on the "Update To" row in the query. Every field that needs to be updated needs to be listed here. The table and field must be formatted in the following way:
[Table].[Field]
-
5
Click on the "Design" tab and select the "Results" group. Click on "Run" from the list. Click "Yes" in the confirmation window. The query will now pull information from both tables for the destination table. Check the information in the destination table for errors and save the file. Click on the "Save" or "Save As" option in the "File" menu. The "Save" option will save over the existing file. The "Save As" option will save the file as a different name or in a different location of your choosing.
-
1
