#error in access query

I have a join that leaves null values, and is supposed to in a query result.
Only supervisors have a supervisor code. Employees do not. I am trying to
evaluate that code to give the manager level.

Manager, Supervisor, Employee. Employee will be null. Managers are less
than 60000 and Supervisors are greater than 60000. I continue to get #error
in my result. I have tried both NZ and several other error functions, with
and without a direct evaluation to 0.

Any suggestions?

MgrLvl: IIf(Right(NZ([OrgSupeIndexCCode]![LinkSupe]),5) Between 1 And 60000,
"M",IIf(Right(NZ([OrgSupeIndexCCode]![LinkSupe]),5)60000,"S","E"))

MgrLvl: IIf(Right(NZ([OrgSupeIndexCCode]![LinkSupe],0),5) Between 1 And 60000,
"M",IIf(Right(NZ([OrgSupeIndexCCode]![LinkSupe],0),5)60000,"S","E"))