Merging Tables

[wyptaj]

I have 2 tables. The 1st table has many fields. The 2nd table has only 2 fields. The 2 fields in the 2nd table do appear in both tables. The second table has more up-to-date information and I want to merge these 2 fields from table 2 into table 1. How is the best way of doing this, so that only the 2 fields in table 1 are updated with the data from table 2.
Please advise,
Thanks

 

[Pat Hartman]

You need a common key to join the two tables on. Otherwise Access would not know how to decide which row in tableA updated which row in tableB.

If you have a common key, you can create an update query.
1. Add the "To" table to the QBE grid.
2. Change the query type to Update
3. Add the "From" table to the QBE grid.
4. Draw the join line between the two key fields.
5. Type [FromTableName].[FromColumnName], using square brackets in the "UpdateTo" cell of the "To" field
6. If you haven't already backed up your data, STOP and do it NOW.
7. Run the query.