View Single Post
Old 07-17-2017, 11:25 AM   #1
jlavin
Newly Registered User
 
Join Date: Jul 2017
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
jlavin is on a distinguished road
Cool Multiple records question

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.

jlavin is offline   Reply With Quote