Update query to coppy data from 1 table into another table

  • Thread starter Thread starter ghadley_00
  • Start date Start date
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
(e-mail address removed)
 
Did you try an update query? Is there a primary key field in each table that
can be used to join the tables?
 
Back
Top