0, 1, 2 become "Eligible", "Not Eligible", "Pending"

Access 2K/XP

I need to display values in a report based on the row value that was entered from a combo box on a form. Unfortunately there is no reference table for the values.

What I get from the field is 0, 1 or 2. On the report I need to show "Not Eligible", "Eligible", or "Pending" based on the field value. This seemed like a no-brainer until I tried to do it. Can't seem to do a case statement in Access queries, haven't found a way to get around it with IIF. It would be silly to have to show an option group for this and I definitely don't want a combo control on the report.

Any other suggestions?

Thanks!

Try using the choose function:
=Choose([FieldValue]+1,"Not
Eligible", "Eligible", "Pending")
This should do it.
Hope it helps.
Fons
-----Original Message-----
Access 2K/XP

I need to display values in a report based on the row
value that was entered from a combo box on a form.
Unfortunately there is no reference table for the values.

What I get from the field is 0, 1 or 2. On the report I
need to show "Not Eligible", "Eligible", or "Pending"
based on the field value. This seemed like a no-brainer
until I tried to do it. Can't seem to do a case statement
in Access queries, haven't found a way to get around it
with IIF. It would be silly to have to show an option
group for this and I definitely don't want a combo control
on the report.

Any other suggestions?

Thanks!
.