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?