Duplicates in a table

[victora]

Hi,
I have a Membership table that contains some duplicates. Although the member# is unique, there are cases like same member using 2 or 3 diff member#s.

I want to print these records. There are several fields that will contain the dup values: LastName, FirstName, MI, Sex & DateofBirth.

How can I select them?

thanks
victora

 

[lbass]

Concatenate the fields {@alldupfields}:

{LastName}&{FirstName}&{MI}&{Sex}&{DateofBirth}

Add the formula to the details section along with {MemberID}.

Then group on the formula and go to edit selection formula-> group and create a group select formula:

distinctcount({MemberID},{@alldupfields})>=2

-LB

 

[synapsevampire]

LB's solution is nicely crafted, however I'd simplify that a bit for detecting more dupes:

uppercase({LastName}+left({FirstName},1)+{Sex}+totext({DateofBirth}))

This should help to discover typos in the first name and lack of middle initial, which is a common dupe criteria. The Uppercase may not be required.

I also added a totext on the dateofbirth assuming that it is a real date field.

-k

 

[victora]

Thank you guys, that one works...Another star for both of you. Thanks again