Results 1 to 6 of 6
  1. #1
    Roberta is offline Novice
    Windows XP Access 2000
    Join Date
    Sep 2010
    Posts
    4

    duplicates


    My table has some duplicate fields. I've been using the wizard (duplicate query) but it doesn't seem to work. When I hit run, the records displayed are 12 (there are 6 unique records - they're doubled after i use the wizard.

  2. #2
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    6 unique records, every have a duplicate one, that is 6 *2 =12.

    it seems just right, what is wrong? or what do you want?

  3. #3
    Rawb is offline Expert
    Windows XP Access 2000
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    The Duplicates Wizard is showing you every Record that has a duplicate and, since both copies of each duplicate are duplicates of each other, both show up (I hope that actually made sense!).

    What you should be able to do once you see the Duplicates is to just remove ONE of them. Then, when you run the Query again, both duplicates will disappear.

    On a related note: Before deleting data like this ALWAY make a copy of your Table(s)

  4. #4
    Roberta is offline Novice
    Windows XP Access 2000
    Join Date
    Sep 2010
    Posts
    4

    duplicate

    The answer is supposed to be 6 queries - the unique ones. I can't eliminate the doubles. The question states that I list full staff details for all duplicated NI numbers

  5. #5
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    Not sure what you want.

  6. #6
    oldman is offline Novice
    Windows 7 Access 2007
    Join Date
    Sep 2010
    Posts
    17
    If you want to remove duplicate records, go to a new table made from the old table. At first you can simply use a "make table" query to create the new table with all fields carried over. It sounds simple and really is that simple.
    Once you have that new table empty it of all content.
    Now design your new table and make the field that should provide a unique record a "KEY" field. That means it will not allow any duplicates in the field.
    Now change your make table query into an "append query". Append your records to the very same table.
    When you run the append query you will get an error message that says that it could not append those 6 duplicate records. The new table will only contain the unique records.
    If I have multiple things that are all involved in determining a duplicate, for example same item ID, same date, same price and whatever else. I create a combo field that contains all of the things that would need to not match to make a record a duplicate. Same ID and different date is OK in this case. The thing I make a "key" in the new table is the field I call combo. That way I don't filter out things that are not really duplicates.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Duplicates in Query
    By Dega in forum Queries
    Replies: 1
    Last Post: 05-02-2010, 05:09 PM
  2. combo box - no duplicates
    By pkg206 in forum Access
    Replies: 1
    Last Post: 11-12-2009, 10:41 AM
  3. How to remove duplicates
    By TonyBender in forum Access
    Replies: 0
    Last Post: 10-21-2009, 10:27 PM
  4. Deleting Duplicates
    By TundraMonkey in forum Queries
    Replies: 4
    Last Post: 09-08-2009, 07:13 AM
  5. Pulling out duplicates
    By FREEEEEEDOM in forum Access
    Replies: 1
    Last Post: 04-21-2009, 10:37 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums