Transferring SQL over to Access VBE pulls NULL set

[RunTime91]

Greetings All...

The below code works perfectly in SQL '14

SELECT MgrName As Supervisor, COUNT(C.Assoc_ID) AS TtlAgents, SUM(CASE WHEN (Status = 'Completed') THEN 1 ELSE 0 END) As TtlCmpltd FROM
	  (SELECT MgrName, Assoc_ID, Full_Nm, IIf(AssocName = Full_Nm,'Completed','Not Completed') As Status FROM
		(SELECT MgrName, Assoc_ID, Full_Nm FROM Tri.vAssocView WHERE MgrName In ('Serb, James','Carrasco, Joyce','Nemeth, Annie','Steffensrud, Janelle',
					'Sharp Garcia, Stacey','Lopez, Stacie') GROUP BY MgrName, Assoc_ID, Full_Nm) A
			LEFT JOIN
		(SELECT AssocID, AssocName  FROM Tri.OneonOne WHERE DateOfReview >'1/31/2020' GROUP BY AssocID, AssocName) B
	ON A.Assoc_ID = B.AssocID) C
	GROUP BY MgrName

The below adaptation to the Access VBE - pulls a NULL set - I've done this many, many times - What am I not seeing??

LstSQL = "SELECT MgrName As Supervisor, COUNT(C.Assoc_ID) AS TtlAgents, SUM(CASE WHEN (Status = 'Completed') THEN 1 ELSE 0 END) As TtlCmpltd FROM " & _
                    "(SELECT MgrName, Assoc_ID, Full_Nm, IIf(AssocName = Full_Nm,'Completed','Not Completed') As Status FROM " & _
                      "(SELECT MgrName, Assoc_ID, Full_Nm FROM Tri_vAssocView WHERE MgrName In ('Serb, James', 'Carrasco, Joyce', 'Nemeth, Annie', 'Steffensrud, Janelle', " & _
                        "'Sharp Garcia, Stacey', 'Lopez, Stacie') GROUP BY MgrName, Assoc_ID, Full_Nm) A " & _
                        "LEFT JOIN " & _
                      "(SELECT AssocID, AssocName  FROM Tri_OneonOne WHERE DateOfReview > '1/31/2020' GROUP BY AssocID, AssocName) B " & _
                  "ON A.Assoc_ID = B.AssocID) C " & _
                  "GROUP BY MgrName"

Thank You as always!!

[June7]

Have you adapted SQL using CASE before? Access SQL engine does not acknowledge CASE.

[RunTime91]

OMG... Nope! Never have - LOL!! Houston! I believe we have identified our problem..

June - You're amazing!! Thank You So Much!!