I have a report that I want data to display very specifically. I want my part name and revision level to show on the report, but if the revision level is blank, to display only the part name. This is what I have in an unbound text field on the report:
=[PartName] & IIf([RevLevel]=" "," "," Rev " & [RevLevel])
What I get is: Part Name Rev NOT just Part Name when the RevLevel is blank. Am I missing something? I don't want the word "Rev" to appear when the field [RevLevel] is blank.
Any advise would be helpful and appreciated.
Heidi
=[PartName] & IIf([RevLevel]=" "," "," Rev " & [RevLevel])
What I get is: Part Name Rev NOT just Part Name when the RevLevel is blank. Am I missing something? I don't want the word "Rev" to appear when the field [RevLevel] is blank.
Any advise would be helpful and appreciated.
Heidi