Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Querying for multiple duplications! (Access 2000 >)

    In reference to <post#=434093>post 434093</post#>, could someone help me with the best approach to solve this issue using find duplicates?!
    Thanx
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Querying for multiple duplications! (Access 2000 >)

    See the attached database.

    I imported the table from the first worksheet, and created queries to return the unique combinations of two fields, for example qryUserID_FullName returns the unique combinations of UserID and Full Name. The Unique Values property of this query has been set to Yes.
    You can then use the Find Duplicates Query Wizard to create a query based on qryUserID_FullName to find duplicate UserIDs, or duplicate Full Names. I have created three of the six possible duplicates queries. Two of these actually return records, the third returns none, indicating that there are no duplicates for that combination.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Querying for multiple duplications! (Access 2000 >)

    Hans, you did not have to do all the work for me, but thanx a stack...that is very clear!
    I appreciate it!
    I will finish the DB based on you example.
    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Regards,
    Rudi

Posting Permissions

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