How to return a zero in a count query for all of a specific field

[Guest]

Here is my Query, I am counting the FP , A/C's that are on site, I have 18
sites. The result only lists the ones in the criteria. Is there a way to have
a zero for the sites that do not meet this criteria?
SELECT Count([A/C].Site) AS CountOfSite, [A/C].Site, [A/C].Status,
[A/C].Section
FROM [A/C]
GROUP BY [A/C].Site, [A/C].Status, [A/C].Section
HAVING ((([A/C].Status)="on site") AND (([A/C].Section)="FP"));

Appreciate any assistance that can be provided

JB

 

[Guest]

UNTESTED --
SELECT Sum(IIF([A/C].[Status]="on site" AND [A/C].[Section]="FP",1,0)) AS
CountOfSite, [A/C].Site, [A/C].Status, [A/C].Section
FROM [A/C]
GROUP BY [A/C].Site, [A/C].Status, [A/C].Section;