"Find Matched" Wizard

Hello!

I have been finding recently that as I go to build queries, and the query
wizard pops up, that none of the options REALLY match what I want to do. I
occasionally end up with identical records in two tables - one that is
SUPPOSED to hold records that are orders in pre-production state, and one
that is SUPPOSED to hold records that are in production and post production
state. (basically devides whether a user can edit the record, or just view
it). However, since my post production table is frequently populated by a
mass import that contains both sets of information, it would be useful to be
able to be able to find records that match records in another table (somewhat
the opposite of the unmatched query wizard). Maybe I just don't know of an
easy way to set this up - but I'm having to create a couple of Unmatched
queries in order to filter out what I want to delete from my post production
table.

Hope that makes sense.

Amanda