Access: exclude data from a query based on two criteria

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

Guest

Re: a query in Access. I want to exclude two descriptions in a field, i.e.,
I have a Division field and I want to exclude "void" and "voidbus". Help!
 
Re: a query in Access. I want to exclude two descriptions in a field, i.e.,
I have a Division field and I want to exclude "void" and "voidbus". Help!
Click to expand...


If the entire field consists of just one word, then as criteria on
that column, write:
Not In("Void","Voidbus")
 
Try

Select * From TableName Where FieldName Not In("void" , "voidbus")

Or,
Select * From TableName Where FieldName <> "void" And FieldName <> "voidbus"
 

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

Access Remove rows based on multiple fields 2
Query criteria - exclude data and return all records if null 3
Exclude data from field, when another field equals a certain numbe 2
two null fields 4
How do you modify / negate criteria based on a form 1
microsoft access 1
Excluding empty fields 4
Data mismatch error 2

Back
Top