I have one database that has First, Last, address, Email, ect. I have
another database that has email and our mailing list location. I want to
combine the two so that list with only the email and mailing list is replced
with the one that has all the contact information. When I am done I should
have all the contact information and the mailing list info. Thank you for
any help

Sorry what I ment to say is I have 2 tables.

"RTHart3" wrote:

> I have one database that has First, Last, address, Email, ect. I have
> another database that has email and our mailing list location. I want to
> combine the two so that list with only the email and mailing list is replced
> with the one that has all the contact information. When I am done I should
> have all the contact information and the mailing list info. Thank you for
> any help

On Mon, 29 Oct 2007 07:31:02 -0700, RTHart3
<(E-Mail Removed)> wrote:

>I have one database that has First, Last, address, Email, ect. I have
>another database that has email and our mailing list location. I want to
>combine the two so that list with only the email and mailing list is replced
>with the one that has all the contact information. When I am done I should
>have all the contact information and the mailing list info. Thank you for
>any help

Create a new table with all of the fields that you need, and run two Append
queries.

Are there duplicate records, i.e. the same person represented in both tables?
If so do you have a *reliable* way to identify the duplicates - a primary key
which uniquely identifies the person? If not you may have difficulties: names
and addresses are not reliable as unique identifiers.

John W. Vinson [MVP]