Drop Down box in query

[Evenflow]

Hello. I have a field in my query called Status. The Status field in my Table has a drop down arrow where you select the status, like "Complete" "In progress" etc. In my query, what do I add to the criteria line to display only the ones complete or in progress? I get an error when I try normal criteria like "Complete" or =Complete. I guess the drop down arrow is causing problems. Thanks.

 

[FoFa]

What is the value stored in the field for "complete" or any status?
If you are getting an error, it must be because it is a different data type.
Remember what you see is not always what is there.