removing records by a list

[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.

 

[JohnFol]

SELECT qryA.MyField
FROM qryA
WHERE (((qryA.MyField) Not In (select MyField from qryB)));

 

[Guest]

Thank YOU
Looks Like I need to learn more commands in the SQL view.

Thanks again.

 

[Michel Walsh]

Hi,


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


Vanderghast, Access MVP