Query to filter all but two items

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

Guest

I have a query that filters data based on a field Status. I want to return
all but two items; "Completed" and "Archived". I know this should be simple
but I can't get them to work togeather. Please help
 
Set the criteria to:

.... WHERE ([Status] <> "Completed") AND ([Status] <> "Archived")

You can also use the Not In () syntax like:

.... WHERE ([Status] Not In ("Completed", "Archived"))
 
Back
Top