DATE TEST
Month Total
2015/04 1
2015/07 1
2015/09 1
2016/01 1
2016/02 1
As you can see from the above results an Access query there are periods without any data. I need them to be displayed within the query as a zero. Can someone tell me how to achieve this easily please.
My query currently reads:
SELECT Format([TimeOfCall],"yyyy/mm") AS [Month], Count([INCIDENT NEW].SALESIncidentIdentifier) AS Total
FROM (SALES LEFT JOIN VICTIM ON SALES.IncidentIdentifier = VICTIM.SALESIncidentIdentifier) RIGHT JOIN [INCIDENT NEW] ON SALES.IncidentIdentifier = [INCIDENT NEW].SALESIncidentIdentifier
WHERE (((VICTIM.VictimType)="1"))
GROUP BY Format([TimeOfCall],"yyyy/mm");
Month Total
2015/04 1
2015/07 1
2015/09 1
2016/01 1
2016/02 1
As you can see from the above results an Access query there are periods without any data. I need them to be displayed within the query as a zero. Can someone tell me how to achieve this easily please.
My query currently reads:
SELECT Format([TimeOfCall],"yyyy/mm") AS [Month], Count([INCIDENT NEW].SALESIncidentIdentifier) AS Total
FROM (SALES LEFT JOIN VICTIM ON SALES.IncidentIdentifier = VICTIM.SALESIncidentIdentifier) RIGHT JOIN [INCIDENT NEW] ON SALES.IncidentIdentifier = [INCIDENT NEW].SALESIncidentIdentifier
WHERE (((VICTIM.VictimType)="1"))
GROUP BY Format([TimeOfCall],"yyyy/mm");