How to set up a criterion that returns everything but one option for that field

S

Sari

One of my fields (called Status) is a dropdown that has the following
choices: New, Assigned To, Defining Issue, Defining Alternatives,
Selecting Alternative, Escalated, Closed.

I want to set up a criterion so that Access will return everything
EXCEPT the Closed items. What is the formula that I need to use for
this? Thanks!
 
R

Rick Brandt

Sari said:
One of my fields (called Status) is a dropdown that has the following
choices: New, Assigned To, Defining Issue, Defining Alternatives,
Selecting Alternative, Escalated, Closed.

I want to set up a criterion so that Access will return everything
EXCEPT the Closed items. What is the formula that I need to use for
this? Thanks!
Click to expand...

SELECT *
FROM TableName
WHERE Status <> "Closed"
 
Top