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

  • Thread starter Thread starter Sari
  • Start date Start date
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!
 
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"
 
Back
Top