Results 1 to 3 of 3
  1. #1
    Join Date
    May 2012
    Posts
    2

    Unanswered: Duplicate records

    I would like to show all duplicate records in a table only when all the checkboxes for each duplicate records are checked off.

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,418
    Provided Answers: 7
    We need more info

    Write a query that's counts the number of id's base on the group by where the count is >1
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    May 2012
    Posts
    2
    Thanks for getting back to me. I'll describe in more details my problem.
    I have a table that consist of multiple columns. One column consist of various duplicate numbers and another column consist of checkboxes. I would like all the duplicate numbers to only show when each checkboxes = yes for those set of duplicate numbers. If all the checkboxes are not equal to yes, then the set of duplicate numbers should not list.

    C1 C2
    5 chkbox
    5 chkbox
    5 chkbox
    6 chkbox

    If all three chkboxes in column2 = yes, then all three duplicate records (5) in column1 should list. If only 2 chkboxes in column2 = yes then none of the duplicate records should show. Thanks for your help
    Last edited by mirza001; 05-28-12 at 21:07.

Posting Permissions

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