MS Access criteria HELP!!

D

dawnovan71

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
 
F

fredg

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'.
 
S

Sandra Daigle

Oops, misread the question - you need to use the like statement:

Not Like "*dog*"
 
Top