Trying to grab only one Status

[SeekerFan]

I am trying to have my query grab only one of the employment statuses. I
created a status table to act as a drop-down for the employee record table
using the LookUp Wizard in the Design view. When the wizard was complete, it
had turned the Status field from Text into Number format.

When I try to have the grab only the M-Day statuses, I use: "M-DAY" in the
criteria, I get an error message that the expression is typed incorrectly, or
it is too complex to be evaluated.

 

[Piet Linden]

I am trying to have my query grab only one of the employment statuses.  I
created a status table to act as a drop-down for the employee record table
using the LookUp Wizard in the Design view.  When the wizard was complete, it
had turned the Status field from Text into Number format.

When I try to have the grab only the M-Day statuses, I use:  "M-DAY" inthe
criteria, I get an error message that the expression is typed incorrectly, or
it is too complex to be evaluated.

If you are doing this directly in the table, don't. Lookups are a
nightmare - just create a combobox in your form and it's really
simple. Then you control what you see and what you get.