I have a report with sub reports. The sub reports are query based. The queries perform a Count. Where no data exists in the table, no results are provided.
Is there a way to populate the sub report field with a 0 when this occurs?
Have tried IIF function in query with no luck.
SELECT QuoteItems.QuoteID, QuoteItems.CleanID, QuoteItems.ContactID, IIf(([CLeanID]) Is Null,0,Count([CleanID])) AS CountOfCleanID
FROM QuoteItems
GROUP BY QuoteItems.QuoteID, QuoteItems.CleanID, QuoteItems.ContactID
HAVING (((QuoteItems.QuoteID)=[Forms]![quotation]![QuoteID]) AND ((QuoteItems.CleanID)=1));