MS Access criteria HELP!!

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

Guest

In Access, How can I set criteria to only choose records NOT containing a
certain word. I get that if I put "dog" in criteria it will show me all
records containing the word dog, but if what if I want all records not
containing the word dog, what do I type for criteria
 
In Access, How can I set criteria to only choose records NOT containing a
certain word. I get that if I put "dog" in criteria it will show me all
records containing the word dog, but if what if I want all records not
containing the word dog, what do I type for criteria
Click to expand...

Not Like "* dog *"

Note the spaces around the word dog. This prevents not getting words
that include dog, such as 'dogmatic'.
 
Back
Top