Multiple iif Statements in 1 Exp

[InsuranceGuy]

That helped a lot--thank you. This should do the trick for you:

SELECT [Supervisor Look Up - 11-9-15].[Employee No] ,[Supervisor Look Up - 11-9-15].[EE Name]
 ,[Supervisor Look Up - 11-9-15].[Direct Supervisor Emp#]
 ,[Supervisor Look Up - 11-9-15].[Direct Supervisor]
 ,[Supervisor Look Up - 11-9-15].[2nd Level Supervisor]
 ,[Supervisor Look Up - 11-9-15].[3rd Level Supervisor]
 ,[Supervisor Look Up - 11-9-15].[4th Level Supervisor]
 ,[Supervisor Look Up - 11-9-15].[5th Level Supervisor]
 ,[Supervisor Look Up - 11-9-15].[6th Level Supervisor]
 ,[Supervisor Look Up - 11-9-15].[7th Level Supervisor]
 ,Switch(IsNull([Level7Exemption].[ee id])
  AND NOT IsNull([7th Level Supervisor]), [7th Level Supervisor], IsNull([Level6Exemption].[ee id])
  AND NOT IsNull([6th Level Supervisor]), [6th Level Supervisor], IsNull([Level5Exemption].[ee id])
  AND NOT IsNull([5th Level Supervisor]), [5th Level Supervisor], IsNull([Level4Exemption].[ee id])
  AND NOT IsNull([4th Level Supervisor]), [4th Level Supervisor], IsNull([Level3Exemption].[ee id])
  AND NOT IsNull([3rd Level Supervisor]), [3rd Level Supervisor], IsNull([Level2Exemption].[ee id])
  AND NOT IsNull([2nd Level Supervisor]), [2nd Level Supervisor], True, [Direct Supervisor]) AS [Highest Supervisor]
 ,[Supervisor Look Up - 11-9-15].[HC Leader 2]
FROM (
 (
  (
   (
    (
     [Supervisor Look Up - 11-9-15] LEFT JOIN [Dept Function EE ID's] AS Level7Exemption
      ON [Supervisor Look Up - 11-9-15].[7th Level Supervisor Emp#] = Level7Exemption.[EE ID]
     ) LEFT JOIN [Dept Function EE ID's] AS Level6Exemption
     ON [Supervisor Look Up - 11-9-15].[6th Level Supervisor Emp#] = Level6Exemption.[EE ID]
    ) LEFT JOIN [Dept Function EE ID's] AS Level5Exemption
    ON [Supervisor Look Up - 11-9-15].[5th Level Supervisor Emp#] = Level5Exemption.[EE ID]
   ) LEFT JOIN [Dept Function EE ID's] AS Level4Exemption
   ON [Supervisor Look Up - 11-9-15].[4th Level Supervisor Emp#] = Level4Exemption.[EE ID]
  ) LEFT JOIN [Dept Function EE ID's] AS Level3Exemption
  ON [Supervisor Look Up - 11-9-15].[3rd Level Supervisor Emp#] = Level3Exemption.[EE ID]
 )
LEFT JOIN [Dept Function EE ID's] AS Level2Exemption ON [Supervisor Look Up - 11-9-15].[2nd Level Supervisor Emp#] = Level2Exemption.[EE ID];

[dmd]

That works PERFECTLY! You are awesome, thank you so much!!!