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