duplicates

[#1]

Is it possible to only display duplicate SSN out of a file?

[Anonymous]

Hi Rob,

Let me understand your requirement correctly.

1. We need to identify duplicate SSN's

2. For the duplicate SSN records we need to identify the duplicate names records. Is that correct or you are looking for something else. Please provide us the requirement in detail.

[#3]

We have staff entering patient data and well they make a few keying errors so we can up with a few different checks to filter thru 78,000 accounts to locate them

First filter

SSN looking for duplicates and merge that patients if they are truly the same.

Second filter

But if the SSN was entered wrong then I need to match up on there name and maybe display birthdate to verify they are not just a totally different person.

I an open to suggestions?

I need to log off soon but will check back in 4 or 5 hours

I actually use the direct connect  SQL

to get data but I run also in excel file to check my apps are linking correctly.