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"
 
Back
Top