Skip to Content
0
Jun 06, 2018 at 05:56 PM

Way to print duplicate records?

64 Views Last edit Jun 06, 2018 at 06:07 PM 2 rev

I am looking at a large data set, and located one client who was a duplicate. They had a different client id, but the name and date of birth and social security number were equal.

I was interested in doing this check in a cr report without having to eyeball.

If we group on first, last names, and social, and date of birth then we would want to display only cases with more than one record. THe only issue is the social security number is not always entered. SO the potential does exist I suppose that 2 people have the same name, and same date of birth.

The only way that comes to mind is to do a count and then it would be easier to see any number other than 1 but is there an even better way to do this?