removing records by a list

Y

yooper_ssm

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

JohnFol

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

yooper_ssm

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

Thanks again.
 
M

Michel Walsh

Hi,


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


Vanderghast, Access MVP
 
Top