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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BigTroubleInLittleChina - 30 Nov 2005 16:32 GMT

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.

Reply to this Message

KARL DEWEY - 30 Nov 2005 17:01 GMT

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.

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

Reply to this Message