I have a report that is connected to the query (below). I want a number to show on the report, but if it is null it is blank, so I want a null to show as 0. Here is my SQL:
SELECT Nz([CountOfStatID],0)+0 AS NP, IIf(IsNull([qryFPCNNewParentSub]![CountOfStatID]),0,[qryFPCNNewParentSub]![CountOfStatID]) AS Expr1
FROM qryFPCNNewParentSub;
It looks convoluted because I was trying to trick it. Can someone help me make the null show as a 0?
The CountOfStatId comes from a sub query. I only need one column to show.
Any help would be appreciated! Thank you!
SELECT Nz([CountOfStatID],0)+0 AS NP, IIf(IsNull([qryFPCNNewParentSub]![CountOfStatID]),0,[qryFPCNNewParentSub]![CountOfStatID]) AS Expr1
FROM qryFPCNNewParentSub;
It looks convoluted because I was trying to trick it. Can someone help me make the null show as a 0?
The CountOfStatId comes from a sub query. I only need one column to show.
Any help would be appreciated! Thank you!