show dups where all fields equal

  • Thread starter Thread starter perryclisbee via AccessMonster.com
  • Start date Start date
P

perryclisbee via AccessMonster.com

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate Table with Fields from Another Table? 6
Populate Table with Fields from Another Table 1
Mutiple Tables Duplicate Field Query 5
Eliminating Dups??? 1
Query based on Query 1
Finding duplicates, then selecting files with different values 1
removing records that look like duplicates but aren't 7
Query Counts based on multiple Query criteria 3

Back
Top