Function to select text strings

[jonnysnow]

There should be a function I'm just not familiar with. I have a table with a coded variable, CLINIC. I want to produce a string on a report, depending on what the variable CLINIC holds.

Example:

CLINIC could be: MGH, HMC, JMH

and on the report, I want:

MGH = Meadowbrook General Hospital
HMC = Harris Medical Center
JMH = Jefferson Memorial Hospital

I know I can use 'Iif':

Iif( [CLINIC] = 'MGH', 'Meadowbrook General Hospital', Iif( [CLINIC] = 'HMC', 'Harris Medical Center', Iif ( [CLINIC] = 'JMH', 'Jefferson Memorial Hospital', '*** BAD VALUE ***')))

But isn't there a simpler way? In this example, I have six different values.

 

[jonnysnow]

Wait!! I realized an obvious way to do this. Just have a translation table of coded value to text string.

Sorry I posted too fast!