I have a report with field plant. The Field holds C incidating Chesterfield, F represents France, G represents Georgia. Problem is on my report, I don't want it to display F, C or G, I want it spelled out.
I need all three iff on one line, but I can't even get one to work.
the control source on the textbox is
=IIf([Plant]="C","Chesterfield","", or [Plant]="F", "France", "")
I need all three iff on one line, but I can't even get one to work.
the control source on the textbox is
=IIf([Plant]="C","Chesterfield","", or [Plant]="F", "France", "")
