If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#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")) |
Thread Tools | |
Display Modes | |
|
|