Unmatched Query to find Changed info between tables

[michael.p.ryan1]

Name: Screenshot_002.jpg  Views: 9  Size: 93.4 KB  ID: 8948" class="thumbnail" style="float:CONFIG" />

I am importing the updated Employee Roster information from Excel to a table called "Weekly Roster Check" (contains new info). I have a table called "Current Chit Board" that has an Employee Roster that I update every week (contains old info). I want a query to find employees who are promoted and their title has changed. then I want to run an update query to update these results to the Current Chit Board table.

Every method I try, returns either no information or information that is not what I want.

[JoeM]

First, regarding Unmatched Queries, you need to use a Left Outer Join in an Unmatched Query, not an Inner Join.

To do this, from the screen shot you posted above, double-click on each join line between the tables and select the option that says something like "Include ALL records from 'Current Chit Board' and only those records from 'Weekly Roster Check' where the joined fields are equal." If you do it right, all you join lines will have arrows on the end pointing to your 'Weekly Roster' table. This would return all records found in the General Chit Board that are not found in the Weekly Roster Check.

However, if you are looking for people who have had title changes, I don't think you want an Unmatched Query. You want a matched query, similar to the one you have. Try removing the criteria you currently have, they under the Title field from the General Chit Board, add the following to the Criteria row:

<>[Weekly Roster Check]![Title]

This should return all records that are found in both tables, but with different titles. I think that is what you are looking for, yes?

[michael.p.ryan1]

First, regarding Unmatched Queries, you need to use a Left Outer Join in an Unmatched Query, not an Inner Join.

To do this, from the screen shot you posted above, double-click on each join line between the tables and select the option that says something like "Include ALL records from 'Current Chit Board' and only those records from 'Weekly Roster Check' where the joined fields are equal." If you do it right, all you join lines will have arrows on the end pointing to your 'Weekly Roster' table. This would return all records found in the General Chit Board that are not found in the Weekly Roster Check.

However, if you are looking for people who have had title changes, I don't think you want an Unmatched Query. You want a matched query, similar to the one you have. Try removing the criteria you currently have, they under the Title field from the General Chit Board, add the following to the Criteria row:

<>[Weekly Roster Check]![Title]

This should return all records that are found in both tables, but with different titles. I think that is what you are looking for, yes?

That worked great, except that I did the opposite

<>[Current Chit Board]![Title]

with the whole query dependent on the Weekly Roster Check table and I got the results I wanted.

Thank-you

[JoeM]

That worked great, except that I did the opposite

Whichever way works best for your situation. I noticed that I thought your original query attempt may have been backwards, but I couldn't be certain and worked off of that assumption.
Either way, it is the same concept.

Glad it all worked out for you!