Search results

Can I make a count default to zero if criteria is not met, rather than passing a null value to a report? <snip> This was originally posted in Report forum and has been followed up on a fair bit if you would like background information please follow this link...

I have a number of queries which when referenced through my report and conditions match work fine. e.g. SELECT Count([Patient Stats].[Anaesthesia Lip]) AS [CountOfAnaesthesia Lip] FROM [Patient Stats] WHERE ((([Patient Stats].Date) Between [Start Date] And [End Date])) GROUP BY [Patient...