IIF with numbers and letters

[hzrdc2]

I hate to be the newb that asks what might be an obvious question... I did search, but I'm not sure I am even searching the proper terms.



I want to have an IIF statement that evaluates numbers and letters:

=IIf([FA]=6565,"EMPLOYEE NAME","")

this works, but when I have an employee code such as 82M8 (containing a letter), it chokes...

Advice?

Thanks,

Scott

[JoeM]

How is the "FA" field defined? What is the data type?
If it has letters in some entries, I would imagine it must have a Text data type. All text entries must be enclosed in quotation marks, i.e.

=IIf([FA]="82M8","EMPLOYEE NAME","")

[hzrdc2]

Yup, you were exactly correct... not sure why I didn't think to try that, guess cause I am still cutting my teeth.

I assume that if I had multiple employee codes, I would create a switch?

=Switch([FA]="6565","NAME 1",[FA]="82M8","NAME 2")

Seems to work