removing records by a list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Group

Problem:
I need to remove entries in a qry that match entries in another.

Example:
qryA qryB
A A
B C
D Z
X
Y
Z

Result:
qryC
B
D
X
Y

The A and Z were removed from qryC

Thanks
Mike S.
 
SELECT qryA.MyField
FROM qryA
WHERE (((qryA.MyField) Not In (select MyField from qryB)));
 
Hi,


You can also run the query wizard about finding unmatched records.


Vanderghast, Access MVP
 
Back
Top