query 2nd column when column 1 is bound

[Mike D.]

My MAIN TABLE has the following field -
Field Name - OPERATOR1
Display Control - Combo Box
Row Source Type - Table/Query
Row Source - EMPLOYEES
Bound Column - 1
Column Count - 2

My EMPLOYEES table has the following records entered -
OPERATOR SHIFT
John Doe 1st shift
Jane Fisher 2nd shift
Jack Baker 1st shift

When doing a query for MAIN TABLE and Field as
OPERATOR1, I can have "Jack Baker" as my criteria and get
the 1 record result as expected.

My problem is that I now want to return all results of
people on 1st shift.
I've tried having the following -
Field - [OPERATOR1].column(2)
Table - MAIN TABLE
Criteria - "1st shift".

I can't seem to get it to work right. What am I missing
here?


Thanks for your help.
Mike D.

 

[anonymous]

Try, in the Criteria Field, Left([Main]![Shift],1)=1.
This will return all the first shift people.