Multiple Not function in Criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
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.
 
Back
Top