Concatenation a value with string on a report

[kw_uh97]

Hello All

I have a field that contains single character values ie

C =closed
M =complete
H =hold
R =ready

that are codes for individual records. I would like to cancatenate a
string or create the word to give it meaning in a report.

I hope I expained this clearly.
Thanks In Advance
Ken

 

[kw_uh97]

To All

I found that the IIf([STATUS]="C","CLOSED","READY") function works
great if I only has two options. But I have 4 options, I thinking I
could use some nesting to accomplish what I want. I dont know if it is
possible to nest multiple IIf statements. But I hear anything is
possible when it comes to programming. Is there a simple solution to
what I am trying to do?

Thanks In Advance
Ken

 

[Larry Linson]

Consider creating a table with the code and descriptions, including that in
the Query on which you base your report, joined to the main table on the
code, but pulling down into the query grid the description for printing on
the report.

Larry Linson
Microsoft Access MVP