Excluding data using criteria

[gary g]

I know I should know the answer to this, but it's been awhile since I've had to design a query. I have a table that includes a column named Status. Data entry for this field is limited to only two options: either Open or Closed.

One of the queries on this table includes Status. If I want the result to show only Open entries, and exclude Closed entries, how would I write the expression in the Criteria line? Earlier I had used the expression <>"Open", which has always worked well until today when it quit functioning for some reason.

To show only specific data using Criteria, am I using the correct expression? Or is it preferable to use an expression that excludes specific data instead?

 

[Beetle]

If you want to return only records with a Status of Open, then in the criteria row for the Status column you would simply put "Open".

 

[gary g]

Thanks Beetle, now I feel really stupid I remembered it being a really simple expression, but I kept trying to make it more difficult. Appreciate the quick help.