Zero values on quarterly chart

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top