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

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