Tricky Query

[Terry]

I have query1 that returns a list of part numbers and query2 that returns a
list of part numbers to be excluded from query1's list. How can I achieve
this with another query.
Regards

 

[Les]

Sounds like the unmatched query wizard will do the trick
for you.

 

[Guillaume Hanique]

You could also have:

Query1: SELECT * FROM Table WHERE Field=Value;

and

Query2: SELECT * FROM Table WHERE ID NOT IN (SELECT ID FROM Query1)

Guillaume Hanique.

 

[Terry]

Thanks for the help, problem now solved.
Regards

You could also have:

Query1: SELECT * FROM Table WHERE Field=Value;

and

Query2: SELECT * FROM Table WHERE ID NOT IN (SELECT ID FROM Query1)

Guillaume Hanique.