Tech Support Guy banner
Status
Not open for further replies.
1 - 3 of 3 Posts

·
Registered
Joined
·
147 Posts
Discussion Starter · #1 ·
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
 

·
Registered
Joined
·
19,896 Posts
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.
 
1 - 3 of 3 Posts
Status
Not open for further replies.
Top