>Works great thanks.
>
>I have one more chalange though.
>
>Each part number in table a has a current engineering drawing revision letter.
>
>Each inspection record in table b also has the engineering drawing level it was checked to. This revision level may have changed since it was inspected. I need a query that will show where table a revisions and table b revisions(greatest date of group) that no longer match.

Do you need a different query? You want to check the latest Revision Level from the TableB, right?