I would like to create a query that will count the number of fields, group by employer then group by month.
The query I currently have seems to just count the number of incidents and group by EMPLOYER. It disregards the start, end point and interval of the partition.
SELECT Count(TABLE.ID) AS Incidents, Partition([INCIDENT_DATE],[Forms]![FORM_HISTOGRAM]![TextSTART],[Forms]![FORM_HISTOGRAM]![TextEND],1) AS [Date], TABLE.EMPLOYER
FROM TABLE
GROUP BY Partition([INCIDENT_DATE],[Forms]![FORM_HISTOGRAM]![TextSTART],[Forms]![FORM_HISTOGRAM]![TextEND],1), TABLE.EMPLOYER;
Thanks-
Kristen