When I copied the query into MS Access - I got and error talking about the keyword AS.  So I removed the second AS facility and it didn't give me...

I copied your query and still get no results back - just field names with no data - I'm sure its me but what am I doing wrong.  StateID is...

They can have any number of certificates - that is why I do it by StateID

SELECT     COUNT(DISTINCT dbo.[Web-Registration-Golf].StateID) AS Lvl2NonPlayCount, dbo.[Web-Registration-Golf].Delegation AS Facility

FROM         dbo.[Web-Registration-Golf] INNER JOIN

                      dbo.certifs ON dbo.[Web-Registration-Golf].StateID = dbo.certifs.Owner

WHERE     (dbo.[Web-Registration-Golf].Unified = 0) AND (dbo.[Web-Registration-Golf].Coach = 1) AND (dbo.certifs.Kind = 'sptf') AND

                      (dbo.certifs.Misc...