criteria help

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

Guest

I have a query with occurence date field and nature field. I need to exclude
5 different words in one field (the nature field). is there a way to do that?
Help greatly appreicated
 
I have a query with occurence date field and nature field. I need to exclude
5 different words in one field (the nature field). is there a way to do that?
Help greatly appreicated
Click to expand...

NOT IN ("this", "that", "theother")

on the Criteria line should do the trick for you.

John W. Vinson[MVP]
 
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

excluding 12:00:00 AM from query results 4
Access Dcount (multiple criteria) 3
Access Remove rows based on multiple fields 2
Date search query 0
Create a query when table has a look up in it 3
Filter by criteria 2
Exporting report into Excel 1
Update primary Key. 1

Back
Top