IIf question

[MGAllen]

Does anyone have an idea as to why "Copy HS Diploma" still shows up when i run this query? I'm sure I'm missing something. I would like to replace the wording with nothing or a dash. Thank you for your help,
Mel


Meets SACS Criteria: IIf([How Criteria Met?]="Copy HS Diploma","-",IIf([How Criteria Met?]="GED","-",IIf([How Criteria Met?]="High School transcript","-",IIf([How Criteria Met?]="Copy Diploma","-",IIf([How Criteria Met?]="Copy High School Diploma","-",IIf([How Criteria Met?]="VOE;","-", IIf([How Criteria Met?]="HS Diploma","-", [How Criteria Met?])))))))

 

[pbaldy]

Works fine in a brief test. Are you sure the input text is exactly that?

 

[Pat Hartman]

You have an old thread on this topic.

Look for a typo. There is nothing wrong with the expression as long as the parser isn't complaining. Double spaces are very hard to see.

You can simplify the expression to one IIf() because all the true cases return the same value - "-" and the final false case returns the column itself.