Choosing Fields that don't exist in another table

  • Thread starter Thread starter RickA
  • Start date Start date
R

RickA

I am sure that this is easy, but I have spent a lot of
time trying to resolve this issue and I have not come up
with a working solution.

I have 2 tables: [table1] & [table2]. Each table has a
similar key field [prodID]. I am trying to create an
append query that gives me all records in [table1] that do
not exist in [table2].

In the query I added the field [prodID] for [table1], and
specified the following in the criteria: "<>[table2].
[prodID]". It seemed to make since to me, but it does not
work.

Any help would be MUCH appreciated.

Rick
 
Hi Rick

not sure about the "append" query - surely you want a "select" type query -
anyway apart from that under the NEW button in the query section is an
UNMATCHED query wizard .. i think this will give you what you're looking
for.

Cheers
JulieD
 
OK, now I feel dumb. Thanks so much for the help. It
worked great.

Rick
-----Original Message-----
Hi Rick

not sure about the "append" query - surely you want a "select" type query -
anyway apart from that under the NEW button in the query section is an
UNMATCHED query wizard .. i think this will give you what you're looking
for.

Cheers
JulieD

RickA said:
I am sure that this is easy, but I have spent a lot of
time trying to resolve this issue and I have not come up
with a working solution.

I have 2 tables: [table1] & [table2]. Each table has a
similar key field [prodID]. I am trying to create an
append query that gives me all records in [table1] that do
not exist in [table2].

In the query I added the field [prodID] for [table1], and
specified the following in the criteria: "<>[table2].
[prodID]". It seemed to make since to me, but it does not
work.

Any help would be MUCH appreciated.

Rick
Click to expand...


.
Click to expand...
 
Back
Top