Update query to coppy data from 1 table into another table

G

ghadley_00

Hi,

I have 2 tables that have entries for items labeld A through Z, and
where table 1's fields are a subset of the fields in Table1. I could
really use some help doing the following:

For every record that exists in table 1 and table 2, I need to copy the
values from the fields in table 2 to table 1.

I think an update query should handle this in MS access, but any
suggestions in general would be greatly appreciated.

Thanks,

George Hadley
[email protected]
 
D

Duane Hookom

Did you try an update query? Is there a primary key field in each table that
can be used to join the tables?
 
Top