Quarter Query with No data

MarieD

Registered User.
Local time
Today, 02:24
Joined
Dec 9, 2009
Messages
53
Can you tell me what to put in this query to make Quarter 1 appear with '0' data if there is not data in the quarter?

TRANSFORM Count([ICD UPGRADE Total Volume qry].PacerorICD) AS CountOfPacerorICD
SELECT [ICD UPGRADE Total Volume qry].NewImplantorGeneratorChange, Count([ICD UPGRADE Total Volume qry].PacerorICD) AS [Total Of PacerorICD]
FROM [ICD UPGRADE Total Volume qry]
GROUP BY [ICD UPGRADE Total Volume qry].NewImplantorGeneratorChange
PIVOT "Qtr " & Format([DateofProcedure],"q");

Here is the query result:

ICD UPGRADE Total Volume qry_CrosstabNew or ChangeTotal Of PacerorICDQtr 2Qtr 3Qtr 4Upgrade8323

I attached the report from this query.

Thanks for your help
 

Users who are viewing this thread

Back
Top Bottom