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

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

Simon