Help with select query criteria needed

[RichardMc]

HI, I have a select query that is pulling data from a table containing name and address info.

I need to specify criteria to pull records where the country field is NOT one of the following:
null
USA
Mexico
Canada

I have tried:
is not null or "USA" or "Mexico" or "Canada"
but that does not work.

Any help much appreciated!
Thanks!

 

[RichO]

How about

Is Not Null And Not In ("USA", "Mexico", "Canada")

 

[RichardMc]

Wonderful!! I knew there had to be a simple answer....
Thanks!!

 

[namliam]

Just a small addendum...

The is not null part is not neccessary (Spelling?!) when using this criteria....

If you compare any text Not in(...)
Or compare any text <> "something"
It will allways return ONLY not Nulls. So if you want to see nulls as well you would have to add: Or is null ....

Doesnt really help, but its the way it is....

Greetz