Crosstab Zero Values

[BobbyBrownPants]

Thanks in advance for any help...

Could anyone fix this to show zero values in the "Total Of ID" column?

TRANSFORM (Count(Inventory.ID)) AS CountOfID
SELECT Inventory.[Patching Status], Count(Inventory.ID) AS [Total Of ID]
FROM Inventory
WHERE (((Inventory.[Patching Status])="ready to plan" Or (Inventory.[Patching Status])="Delayed" Or (Inventory.[Patching Status])="up to date" Or (Inventory.[Patching Status])="planned" Or (Inventory.[Patching Status])="up to date oos") AND ((Inventory.[Application Tab])="esx"))
GROUP BY Inventory.[Patching Status]
PIVOT Inventory.[Application Tab];


Thanks
Bobby

 

[bachfan23]

TRANSFORM (Count(Inventory.ID)) AS CountOfID
SELECT Inventory.[Patching Status], Iif(Count(Inventory.ID)>0,Count(Inventory.ID),0) AS [Total Of ID]
FROM Inventory
WHERE (((Inventory.[Patching Status])="ready to plan" Or (Inventory.[Patching Status])="Delayed" Or (Inventory.[Patching Status])="up to date" Or (Inventory.[Patching Status])="planned" Or (Inventory.[Patching Status])="up to date oos") AND ((Inventory.[Application Tab])="esx"))
GROUP BY Inventory.[Patching Status]
PIVOT Inventory.[Application Tab];