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,475
    Provided Answers: 11
    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

    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-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

  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 20: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
  •