Hello, I hope my 'long title' wasn't too confusing...
I have a dateadd function of '>=DateAdd("q",-8,Date())'
SELECT DatePart('yyyy',[datepurchased]) AS yrs, DatePart('q',[datereported]) AS qtrs, product FROM Cust
WHERE (((datepurchased)>=DateAdd("q",-8,Date())))
There was nothing purchased in the 1st Qrt of this year but there were products purchased in previous quarters and after.
The graph I built of course does not bring and data back for the first quarter. Is there a way to bring in '0' for this?
Please let me know if you would like me to clarify.
Thanks for any help you can provide!
TD