Changing a Field to more Descriptive Word in Report

[JWeaver]

I have a field in my database that is used to track 3 program types that are
1 character in length. The report is designed to sort by program types and
give a total for each for each employee. Is there a way to convert this one
character to the actual program type on the report? For example, I want to
convert "P" to "PAL" in the report detail summary line.

I appreciate your assistance!

 

[fredg]

I have a field in my database that is used to track 3 program types that are
1 character in length. The report is designed to sort by program types and
give a total for each for each employee. Is there a way to convert this one
character to the actual program type on the report? For example, I want to
convert "P" to "PAL" in the report detail summary line.

I appreciate your assistance!

Do you mean the value of a field in the report can be "P" and you want
it top display "PAL" in the report?
Here is the syntax for 3 possible values, using an unbound text
control:
=IIf([SomeField]= "P","PAL",IIf([SomeField] = "X", "SomeThingElse","A
third value"))

 

[JWeaver]

Thanks, that worked great! I appreciate your help.
--
JWeaver

I have a field in my database that is used to track 3 program types that are
1 character in length. The report is designed to sort by program types and
give a total for each for each employee. Is there a way to convert this one
character to the actual program type on the report? For example, I want to
convert "P" to "PAL" in the report detail summary line.

I appreciate your assistance!

Do you mean the value of a field in the report can be "P" and you want
it top display "PAL" in the report?
Here is the syntax for 3 possible values, using an unbound text
control:
=IIf([SomeField]= "P","PAL",IIf([SomeField] = "X", "SomeThingElse","A
third value"))