Solved: Duplicate Mail merge - Access?

[Simon71]

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]

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]

Hi Tony,
Once again you are a genius sir. Thanks for your help.

Simon