How do I merge two records from the same table into one record?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to take two records with the same key fields but missing data and
merge them together to make one complete record. For example, record A has
name but address and phone number are blank while record B has address and
phone number but name is blank. I want to take the address and phone number
from record B merge it with Record A to give me one complete record.
 
Use an update query with criteria for the field as Is Null - this fills in
the blanks.

You will need to do a separate update query for each field.
 
Back
Top