Hello,
I built a nice chart to count the number forms made by each of our 3 shifts based upon a time frame. However, I cannot find out how to show the date range on the chart.
The query has two sections
It has the date field with criteria
Code:
Between [Enter the start date:] And [Enter the end date:]
and the Shift field that only contains A,B, or C.
The chart row source line is this
Code:
SELECT shiftdate.shift, Count(shiftdate.Date) AS CountOfDate FROM shiftdate GROUP BY shiftdate.shift;
If I was to select a date from 1/1/14 to 7/2/14 how do I show this on the chart when I run the report?
Thank you for your help