|
| |
|
|
ktran40
Posts: 1
Joined: 5/9/2007
Status: offline
 |
MS AccessS: Comparing data - 5/9/2007 15:22:05
Hi,
I have a big table called "Identification" that holds a ton of people's names.
The Identification table amongst other fields contains ID, First Name, and Last
Name. I have another table that is called "Salutation". In the salutation
table and the salutation field, a record could say "Ms. Kempen", "Mr. and Mrs.
Kempen", "Mrs. Kimberly A. Kempen", or the last name may different all together.
The salutation also has ID as a field and can be linked to the Identification
table.
I would like to create a query that shows me all the records where the last name
from "Identification" table does not match the last name of the "Salutatiion"
table. The "Identificatiion is more accurate, so if they differ, I need to know
which records are different so that we can research and fix the salutation
table.
I hope I am clear enough.
Thanks,
|
|
|
|
treetopsranch
Posts: 961
From: Cottage Grove, OR, USA
Status: online
|
RE: MS AccessS: Comparing data - 5/9/2007 16:51:06
quote:
MS Access
I found a Access forum for you to ask that question:
http://www.access-programmers.co.uk/forums/
_____________________________
Don from TreeTops Ranch, Oregon
"I've got a taste for quality and luxury"
| |
|
|
|
swoosh
Posts: 1428
Joined: 5/18/2002
From: Beaver Falls, PA
Status: offline
|
RE: MS AccessS: Comparing data - 5/9/2007 17:10:12
Have you tried using the "Find Unmatched Query Wizard"?
_____________________________
Swoooosh
Just Do It!
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
