HOW DO I SET UP A "DOES NOT EQUAL" FORMULA IN DATABASE?

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

Guest

I am running a query for information based upon some invoices and want to
eliminate those invoices that contain specific words in a particular field.
How do I do that?
 
Mark said:
I am running a query for information based upon some invoices and
want to eliminate those invoices that contain specific words in a
particular field. How do I do that?
Click to expand...

WHERE FieldName Not Like "*SomeWord*"
AND FieldName Not Like "*SomeOtherWord*"
etc...
 
Back
Top