Access QC Check on two tables
I have two tables and would like to have a query that looks at a *field in both tables to see if they match and display both Fields mismatches.
Join = SSAN
Table one = PERSTYPE
*Field = DUTY
Field =NAME-IND
Table two = TECH
*Field = DCODE
Field = Name Employee
Join = SSAN
Table one = PERSTYPE
*Field = DUTY
Field =NAME-IND
Table two = TECH
*Field = DCODE
Field = Name Employee
ASKER
I just realized that in some cases the two are not exactly the same. Like one table might have 15B and the other table would have 15B00.
*Field = DUTY
*Field = DCODE
How can I display all information to see what the DUTY and DCODE shows for both tables?
Table one = PERSTYPE
*Field = DUTY
Field =NAME-IND
Table two = TECH
*Field = DCODE
Field = Name Employee
*Field = DUTY
*Field = DCODE
How can I display all information to see what the DUTY and DCODE shows for both tables?
Table one = PERSTYPE
*Field = DUTY
Field =NAME-IND
Table two = TECH
*Field = DCODE
Field = Name Employee
upload a copy of the db..
the name field in the TECH table have comma on it, all records will not match.
ASKER
can you match the SSAN
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It runs ok...but I didnt menchion that the record count on each table is different. The TECH table has around 400 and the PERSTYPE has around 1000. So, when I run the query on the production DB I get the 400 that match but I also get the 600 that dont. I only need the matching.
ASKER
Never mind, I ran the query wiz for dups.
Thanks.
Thanks.
select Find Unmatched Query Wizard