Return zero

[linda55]

Can anyone tell me how to alter this so I get a zero when there are no entries to sum
TRANSFORM Sum([Daily Entries].Credit) AS [The Value]
SELECT [Daily Entries].RevNo, Sum([Daily Entries].Credit) AS [Total Of Credit]
FROM [Daily Entries]
WHERE ((([Daily Entries].AcctNo)=".08&quot)
GROUP BY [Daily Entries].RevNo, [Daily Entries].AcctNo
PIVOT Format([Date],"mmm&quot In ("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"

I have looked in keyword search and can't find enough help for my limited knowledge. I would really appreciate your help.

 

[IFELSETHEN]

Might want to look at the IIF statement.
John

 

[cmmrfrds]

Sum(iif([Daily Entries].Credit is not null,[Daily Entries].Credit,0)) AS [Total Of Credit]

basic syntax
iif (expression, true, false)