| | |
|
|
|
Concatenation a value with string on a report |
|---|
| message from kw_uh97 on 7 May 2004 |
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 replied to kw_uh97 on 7 May 2004 |
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 replied to kw_uh97 on 15 May 2004 |
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
"kw_uh97" <kw_uh97.15x89z@nospam.MSAccessForum.com> wrote in message
news:kw_uh97.15x89z@nospam.MSAccessForum.com...
|
|
Archived message: Concatenation a value with string on a report (MS Access Forms)
