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
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.
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.
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