Trying to grab only one Status

  • Thread starter Thread starter SeekerFan
  • Start date Start date
S

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.
 
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.
Click to expand...

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.
 
Back
Top