If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
0, 1, 2 become "Eligible", "Not Eligible", "Pending"
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! . |
Thread Tools | |
Display Modes | |
|
|