1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Duplicate Mail merge - Access?

Discussion in 'Business Applications' started by Simon71, Jan 23, 2007.

Thread Status:
Not open for further replies.
  1. Simon71

    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
     
  2. OBP

    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.
     
  3. Simon71

    Simon71 Thread Starter

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

    Simon
     
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 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/537646

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice