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'.
 
Oops, misread the question - you need to use the like statement:

Not Like "*dog*"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In Access, How can I set criteria to only choose records NOT cont. 1
Access Dcount (multiple criteria) 3
Access Access Query Criterion 1
How to exclude certain records 7
query tables using multiple listed values from another table 1
VBA: How can I use a string variable as autofilter criteria? 4
Use criteria in field for fieldname in query 2
Query criteria 2

Back
Top