update

  • Thread starter Patrick Stubbin
  • Start date
P

Patrick Stubbin

I have two tables, with almost equal values except the entry for one field is
blank.

how do i update the blank values in one table and replace those said blanks
with the entry from the other table for the same record
 
V

Van T. Dinh

Do you have a common Field that uniquely identifies Record in both Tables?

If you do, you can use and Update Query like: (RecordID for example):

UPDATE tblA INNER JOIN
tblB ON tblA.RecordID = tblB.RecordID
SET tblA.RequiredField = tblB.RequiredField
 
Top