SELECT d.GroupId, Sum(d.cert_complete) AS SumOfcert_complete, Count(d.cert_complete) AS CountOfcert_complete FROM (SELECT DISTINCT s.GroupId, e.EmployeeID, IIf(e.Certified Is Null,0,1) AS cert_complete FROM (Stores AS s INNER JOIN EmployeeStores AS es ON s.StoreId=es.StoreId) INNER JOIN Employees AS e ON es.EmployeeId=e.EmployeeID) AS d INNER JOIN Groups ON d.GroupId = Groups.GroupId GROUP BY d.GroupId;Once it's in, I'm going to add
WHERE Titles.IsManagerProblem is, I don'tm understand this goofy sql syntax access uses. The nested joins are driving me crazy.