right expression needed

  • Thread starter Thread starter Penny
  • Start date Start date
P

Penny

Help please!
I have 4 check boxes showing in an employee listing, only
one of those boxes is checked per employee. How do I have
the query only show the box that's checked for each
employee and not show the others?

Thanks in advance for your time.

Penny
 
This is one of those questions that would be infinitely clearer if you would
type in about 6-10 records and the expected results.
Since users can only check one of the four boxes, it makes good sense to
store a value in a single field. For instance, if your fields were for race
and the field names were:
Caucasian
African American
Asian
Native American
You could use one field for race with a lookup table with a RaceID field and
the Race Name. Store the RaceID in the employee table.

If you can't change your structure then please come back with your field
names and some sample data as well as expected results.
 
Back
Top