Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006
    Michigan, US

    Question Unanswered: Remove duplicates based on a field

    I want to open my "contacts" table in a database, and remove every record from it that contains duplicates in the "MgmntFax" field so I am left with a good list for faxing too. I don't want to hide it, but completely rip it out of there. Then save the results in a "FaxContacts" table in a new "FaxContacts" database. I working with Access 2000. Is this possible?

    Thanks in advance for any help.

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    Uhhh... how about using a SELECT DISTINCT statement instead?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts