You should check your query. For 3/6/2015, I counted 5 records but the query returned a count of 8.
This is the query from your dB. Notice the date:
Code:
SELECT tbl_Data.Date_Created, Count(tbl_Data.Record_ID) AS CountOfRecord_ID
FROM tbl_Data
WHERE (((tbl_Data.Date_Closed) Is Null Or (tbl_Data.Date_Closed)>3/#1/1/2017#))
GROUP BY tbl_Data.Date_Created;
Changing the SQL to
Code:
SELECT tbl_Data.Date_Created, Count(tbl_Data.Record_ID) AS CountOfRecord_ID
FROM tbl_Data
WHERE (((tbl_Data.Date_Closed) Is Null Or (tbl_Data.Date_Closed)>#3/1/2017#))
GROUP BY tbl_Data.Date_Created;
provides a count of 5 for the created date of 3/6/2015......