Multiple "Not equal to" Criteria 1

[izzyq]

Is it possible to add multiple (<>) Not equal to Criteria when trying to filter out an access query. For Example returning data that does not equal 50948E and 54806L and 54821. Help Me Obi Wan Kenobi, You're My Only Hope.

 

[IFELSETHEN]

Yes use the IN operator with the NOT operator, like this:

NOT IN (50948E, 54806L, 54821)

Regards,
John, vb_doc@hotmail.com

 

[dalchri]

I recommend using an in clause. For example:
[tt]
SELECT *
FROM YourTable
WHERE Not YourField In ('50948E','54806L','54821')
[/tt]