Not operator

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

Guest

Hello,

I am trying to use the "Not operator" in a query criteria row to exclude
country fields that start with "S". For example, South Africa, South Korea,
Spain etc. So far my attempts have failed.

I tried:

Not In ("S*")

I also tried:

Not = "S*"

So far, none of this operators appear to be providing the results I hoped
for. Are my leaving something out? I will appreciate any help.

Thanks
 
Greg said:
Hello,

I am trying to use the "Not operator" in a query criteria row to
exclude country fields that start with "S". For example, South
Africa, South Korea, Spain etc. So far my attempts have failed.

I tried:

Not In ("S*")

I also tried:

Not = "S*"

So far, none of this operators appear to be providing the results I
hoped for. Are my leaving something out? I will appreciate any help.

Thanks
Click to expand...

Not Like "S*"
 
Back
Top