"Amanda Payton" wrote in message
news
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

Hi Amanda,

Separating the records into two different tables is just asking for problems
of the kind you describe. It would be far better to have just one table,
with some kind of status field that gets updated as things change.

Anyway, to find matching values in two tables all you need is a simple join.
Open the query designer, add both of the tables, and just click and drag
from the matching field in one table to the matching field in the other to
create a join.