Multiple Not function in Criteria

[Guest]

I want to filter out specific cities within a field named CITY through a
query. I have used NOT and <>. For example NOT "city1" or "city2" or
"city3" in a query line and then in a column format.
I have also tried NOT "city1" or Not "city2". Only the first listed city is
filtered out regardless of syntax used. What should the syntax be? Thank
you very much.

 

[Guest]

Use --
<> "city1" And <> "city2" And <> "city3"

 

[Guest]

Try this

Select * From TableName Where City Not In("city1" ,"city2" ,"city3")

 

[[MVP] S.Clark]

WHERE City NOT IN ("city1", "city2")

 

[Guest]

thank you Karl just as I was looking for.

Use --
<> "city1" And <> "city2" And <> "city3"

 

[Guest]

I was actually looking for what Karl provided me but you and Ofer provided me
gives me so insight as for as SQL scripting. Thank you.

 

[Guest]

I was actually looking for what Karl provided me but you and Steve provided
me gives me so insight as for as SQL scripting. Thank you.