I am looking at a table that could have the same person on it more than once. A visit table. I have a unique ID and DOB on this table.
We have had some data entry issues and I would like to look at this moving forward as well, so what I am trying to do is list all the people and all their records that have DOBs that are not all the same.
For example - the filter should show both Person A records from below.
Name DOB
Person A 1/1/1950
Person B 2/2/1960
Person C 3/5/1999
Person A 1/2/1950
I hope this makes sense. I really appreciate any help. I tried searching for this but didn't find any "multiple record" posts where having multiple records was a good thing.
We have had some data entry issues and I would like to look at this moving forward as well, so what I am trying to do is list all the people and all their records that have DOBs that are not all the same.
For example - the filter should show both Person A records from below.
Name DOB
Person A 1/1/1950
Person B 2/2/1960
Person C 3/5/1999
Person A 1/2/1950
I hope this makes sense. I really appreciate any help. I tried searching for this but didn't find any "multiple record" posts where having multiple records was a good thing.