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

[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.

 

[Guest]

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.