Using "Not Like" in a query

[DMetcalfe]

Hi,



I wish to restrict a query by not showing entries for a list of people who have left the company

In the "name" field on my Query, If i put "Like [Leavers]![Leavers]" It will restrict the query to ONLY the people who have left. I wish to reverse this and show everyone apart from the people who have left

I thought a simple "Not Like [Leavers]![Leavers]" would work, but it doesnt.
I've also tried "Not [Leavers]![Leavers]", which still gives me no luck.

Please help me?
Thanks

[ajetrumpet]

this would work:

WHERE FIELD NOT IN (

SELECT FIELD FROM TABLE WHERE

FIELD LIKE LEAVERS!LEAVERS)

[pbaldy]

Try the unmatched query wizard. On large data sets the join method will be more efficient than a subquery.

[ajetrumpet]

Thanks Paul