G
george 16-17
Greetings,
I am in need of some assistance. I have a quarterly line chart that is not
returning any zero values for quarters that do not have records. Is there a
simple method to include the zeros?
Here is my rowsource statement:
SELECT (Format([Date of Inj],"QQ 'YY")),Count(*) AS [Count] FROM [qrySearch]
GROUP BY (Year([Date of Inj])*4 + DatePart("q", [Date of
Inj])-1),(Format([Date of Inj],"QQ 'YY"));
Thanks in advance,
george
I am in need of some assistance. I have a quarterly line chart that is not
returning any zero values for quarters that do not have records. Is there a
simple method to include the zeros?
Here is my rowsource statement:
SELECT (Format([Date of Inj],"QQ 'YY")),Count(*) AS [Count] FROM [qrySearch]
GROUP BY (Year([Date of Inj])*4 + DatePart("q", [Date of
Inj])-1),(Format([Date of Inj],"QQ 'YY"));
Thanks in advance,
george