M
MN
Hi - I have this query below, but the data do not have First quarter, so how
can I list them on the report? Thank you for any reply.
Query come out with the result like this:
County Countyname Q2 Q3 Q4
TRANSFORM Count([client].[county]) AS CountOfCountycode
SELECT [client].[county], [CountyCode].[Countyname]
FROM client INNER JOIN CountyCode ON [client].[county]=[CountyCode].[Cntycode]
GROUP BY [client].[county], [CountyCode].[Countyname]
PIVOT "Q" & Format([cln_cls_dt],"q");
can I list them on the report? Thank you for any reply.
Query come out with the result like this:
County Countyname Q2 Q3 Q4
TRANSFORM Count([client].[county]) AS CountOfCountycode
SELECT [client].[county], [CountyCode].[Countyname]
FROM client INNER JOIN CountyCode ON [client].[county]=[CountyCode].[Cntycode]
GROUP BY [client].[county], [CountyCode].[Countyname]
PIVOT "Q" & Format([cln_cls_dt],"q");