I have an Access 2003 database with a report that does not display all of the records in the query that populates it. The query for the report looks like this:
SELECT Incidents.[Incident number], Incidents.DateTimeCaseOpened, Incidents.CurrentStatus, Incidents.IncidentClassification, Incidents.L2, Incidents.L2
FROM Incidents
WHERE (((Incidents.DateTimeCaseOpened) Between [Forms]![Database Update and Report Form]![From] And [Forms]![Database Update and Report Form]![To]));
The report appears to disclude records from the last day of the month. There are no other filters in the query. Any ideas?
Thank you in advance.
SELECT Incidents.[Incident number], Incidents.DateTimeCaseOpened, Incidents.CurrentStatus, Incidents.IncidentClassification, Incidents.L2, Incidents.L2
FROM Incidents
WHERE (((Incidents.DateTimeCaseOpened) Between [Forms]![Database Update and Report Form]![From] And [Forms]![Database Update and Report Form]![To]));
The report appears to disclude records from the last day of the month. There are no other filters in the query. Any ideas?
Thank you in advance.