Query by DOB

[Annette]

I have two table (imported from excel) that contain client data. Both
tables have client last name,first name and dob. Is there I way that
I can find the differences between the tables based on the names in
relation to the dob?

For example, table A has a client named Mark Anderson with a dob of
01/14/1997 and table B has a client named Mark Andersen with a dob of
01/14/1997. If I did a query linking the two tables by dob, these
records would link and I could tell that perhaps they could be the
same person with a miss-spelling or I need to investigate further.

Another example would be table A has client John O'Malley with a dob
of 12/15/1970 and table B has a client John OMalley with a dob of
12/15/1970. Chances are these are the same people, but the name is
miss-spelled.

Final example would be table A has a client Nick Johnson with a dob of
06/16/2000 and table B has a client Nicholas Johnson with a dob of
06/16/2000. Most likely these are the same people.

I would like to have a query that shows me these differences, when the
tables are linked by dob.

Any ideas?

 

[John W. Vinson]

I have two table (imported from excel) that contain client data. Both
tables have client last name,first name and dob. Is there I way that
I can find the differences between the tables based on the names in
relation to the dob?

For example, table A has a client named Mark Anderson with a dob of
01/14/1997 and table B has a client named Mark Andersen with a dob of
01/14/1997. If I did a query linking the two tables by dob, these
records would link and I could tell that perhaps they could be the
same person with a miss-spelling or I need to investigate further.

Another example would be table A has client John O'Malley with a dob
of 12/15/1970 and table B has a client John OMalley with a dob of
12/15/1970. Chances are these are the same people, but the name is
miss-spelled.

Final example would be table A has a client Nick Johnson with a dob of
06/16/2000 and table B has a client Nicholas Johnson with a dob of
06/16/2000. Most likely these are the same people.

I would like to have a query that shows me these differences, when the
tables are linked by dob.

Any ideas?

Well, just do so. Create a query; add both tables; join by DOB, and select the
name fields from both tables. You can put a criterion on Table1.FirstName of

=[Table2].[FirstName]

and the same for LastName to find the exact matches; change either or both =
to <> to find mismatches.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com