Query to merge two tables based on common entries?

[LordJezo]

Say I have table A with fields 1, 2, 3, 4, and 5 and then a table B also with fields 1, 2, 3, 4, and 5. I want to merge table A into table B.

I want to take entries 3, 4, and 5 from table B and match them up in table A where both entries 1 and 2 are the same.

For example, if table A and table B had the same entry in both the first and second fields, take the third, fourth, and fifth from table B and put them into table A. If fields 1 and 2 do not match up in both tables, do nothing and leave table A alone in that field.

 

[FoFa]

Use an update query, join table A to table B on the two fields (where both must be equal), then in the updated to put the table B columns in the proper table A columns.

 

[LordJezo]

Use an update query, join table A to table B on the two fields (where both must be equal), then in the updated to put the table B columns in the proper table A columns.

Is there any easy way to make an update query?

 

[Mile-O]

Use the query design view, and select UPDATE from the Query menu.