IIF In Query

[jo15765]

I need my query to manipulate some field data for me


If employeeName = James Jones show JJ
If employeeName = Richard Barker show RB
Else show employeeName

I know you can use the below to format both fields, but what about my else

FormatMe: IF([employeeName]="James Jones", "JJ", IIF([employeeName] = "Richard Barker", "RB"))

[Bob Fitz]

Try:
FormatMe: IIF([employeeName]="James Jones", "JJ", IIF([employeeName] = "Richard Barker", "RB",[employeeName]))