Solved: Duplicate Mail merge - Access?

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Simon71

Thread Starter
Joined
Feb 9, 2005
Messages
147
Hi All,
I have 2 Access tables containing customer details. One for 2 different companies. I want to produce a mail merge of both sets of data but DO NOT want to send to the same company twice. Both my tables may have duplicte companies in them!

In Access, I have appended both tables into one MAIN table. I then run a find duplicates query, which finds the dublicates OK. I now want to delete these duplicates but keep one record of the company.

Can anyone sugegst how I can do this?

e.g.
Table 1.
Company A
Company B
Company C

Table 2.
Company C
Company D
Company E

I have combined both tables:
Table 3.
Company A
Company B
Company C
Company C
Company D
Company E


I want to delete 1 record of Company C but keep the other one!
Is this clearer?

Thanks

Simon
 

OBP

Joined
Mar 8, 2005
Messages
19,895
Hello Simon, long time no see.
Why don't you just set the "New Combined" Table to have no Duplicates in the Company field, that way when you append the data only one record will be accepted.
 

Simon71

Thread Starter
Joined
Feb 9, 2005
Messages
147
Hi Tony,
Once again you are a genius sir. Thanks for your help.

Simon
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top