How do I code this query?

M

mscertified

I have 2 tables A and B. I need to update a column in table A with the
contents of the same column in table B. To match the rows I need to compare
on 4 other columns in each table.
Basically what I have is 2 identical tables but one column is in error in
table A so I need to load it from table B.
Anticipating your question, no I can't just use table B.

I tried Access help but it assumes you are reading from the same table that
is being updated.
 
B

Brian

Create a new query
Add tables A & B
Join these on ALL 4 FIELDS in common
Change it to an update query.
Field: Field5
Table: TableA
Update To: [TableB]![Field5]
 
Top