If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
show dups where all fields equal
I have a detailed patient information table with instances where there are
duplicate claim numbers . I ran a query that showed all cases where the claim number count 1. Based on this, how would you write a query that would show all cases where ALL the fields for those duplicate claims are equal? Thanks, Perry -- Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
show dups where all fields equal
Sounds to me like you want the Find Duplicates Query which is a Wizard when
making a new query. From there if you want something more specific, I'd then change the query which Access created. James "perryclisbee via AccessMonster.com" wrote: I have a detailed patient information table with instances where there are duplicate claim numbers . I ran a query that showed all cases where the claim number count 1. Based on this, how would you write a query that would show all cases where ALL the fields for those duplicate claims are equal? Thanks, Perry -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|