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
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