Where condition

  • Thread starter Thread starter Jan
  • Start date Start date
J

Jan

I have created a form with two options...The first button
uses the "like" function to isolate certain values. Ex:
like '*reported'. That works as expected. The second
button I want to behave in the opposite manner. For
example, I want all the values that don't
contain "reported". I tried several things and can't get
this to work....Can anybody help?

Thanks in advance,

Jan
 
Try:
Not Like "*reported"

Neither of those returns the records where the field is Null, so if your
intention was to grab all the others, you might use:
Is Null OR Not Like "*reported"
 
Back
Top