Query to filter all but two items

D

DDBeards

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
 
V

Van T. Dinh

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