View Full Version : Quarter Query with No data


MarieD
01-19-2010, 10:55 AM
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