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
Debra Farnham - 06 Jul 2006 19:11 GMT
Hi Greg
Try
Not Like "s*"
HTH
Debra
> Hello,
>
[quoted text clipped - 15 lines]
>
> Thanks
Rick Brandt - 06 Jul 2006 19:13 GMT
> Hello,
>
[quoted text clipped - 14 lines]
>
> Thanks
Not Like "S*"

Signature
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com