Query Question

[Dee]

I need to create a query where one of the fields I need to query is a combo
box. When I look at the datasheet, the field show 1, 2, 3, or 4 which are the
4 choices. Is there a way to have Access show the actual choice i.e. complete
response, progression, partial response, stable. I am using Access 2003.

Thanks in advance for your help.

Best regards,

Dee

 

[Duane Hookom]

Add the table to the query that stores the actual text values of the "choice".