Concatenation a value with string on a report

  • Thread starter Thread starter kw_uh97
  • Start date Start date
K

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
 
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
 
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
 
Back
Top