Crosstab Zero Values

B

BobbyBrownPants

Joined
Jun 7, 2012
Messages
2
Reaction score
0
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
 
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];
 
Back
Top