I have two tables that contain SSN as primary keys.
note: (Table 1 has 645 records, table 2 has 606 records. Both tables contain the same information, they just come from different sources. My end-users want to see what personnel are missing from table 2).
I create a relationship using SSN and I tried to
do a unmatch query, but it only returned 45 records.
I printed both list and reviewed the SSN numbers, greater than 95% of them matched. so why only 45 matched? I tried changing Joins, field properties, I don't know why I can't get more names to matchup.
note: (Table 1 has 645 records, table 2 has 606 records. Both tables contain the same information, they just come from different sources. My end-users want to see what personnel are missing from table 2).
I create a relationship using SSN and I tried to
do a unmatch query, but it only returned 45 records.
I printed both list and reviewed the SSN numbers, greater than 95% of them matched. so why only 45 matched? I tried changing Joins, field properties, I don't know why I can't get more names to matchup.