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