Query Differences from 1 table to another - is it possible?

[Maven4Champ]

This is probably simple but i am not sure.

Basically I have 1 table with sr_number field and dept field.

One table will be called tblOriginalSR and the other will be called tblNewSR

What I want to do is say "Show me what is in tblOriginalSr that is not in tblNewSR - thus showing me the discrepencies/differences in the data so that I can further investigate.

Is this possible?

 

[Norie]

Why not use the Find Unmatched Query Wizard?

Just go to the Queries tab and select New, pick that option and follow the steps.