Query to filter all but two items

[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

 

[Duane Hookom]

Set the criteria under Status to:
Not In ("Completed", "Archived")

 

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