[AccessD] Problem Making Query

[FW Salato Center]

A WHERE or HAVING clause might be in order. 

If count of active = 0, don't include 

Susan H. 

That's the problem.  I don't have any SQL for the active and complete.  I tried but could not get either one to work.

The SQL for the case for both active and complete is trivial:

SELECT DISTINCT tblMarketingActivitiesProjectNumber.fldMAProjectNumberID,
tblMarketingActivitiesProjectNumber.fldMAProjectNumber
FROM tblMarketingActivitiesProjectNumber
ORDER BY tblMarketingActivitiesProjectNumber.fldMAProjectNumber;

R