Code:
SELECT qryIncidentDetails.[Job No], qryIncidentDetails.[Incident Number], qryIncidentDetails.[Issued to], qryIncidentDetails.Severity, qryIncidentDetails.Safety, qryIncidentDetails.Environmental, qryIncidentDetails.Quality, qryIncidentDetails.Complaint, qryIncidentDetails.[Near hit], qryIncidentDetails.Other, qryIncidentDetails.Location, qryIncidentDetails.[Incident Date], qryIncidentDetails.Detail, qryIncidentDetails.[Incident Description], qryIncidentDetails.Reporter, qryIncidentDetails.[Imediate Action], qryIncidentDetails.[Completion Due], qryIncidentDetails.[Completed Date], qryIncidentDetails.Completer, qryIncidentDetails.[Root Cause], qryIncidentDetails.[Long Term Action], qryIncidentDetails.[Responsible 1], qryIncidentDetails.[Responsible 2], qryIncidentDetails.[Date 1], qryIncidentDetails.[Date 2], qryIncidentDetails.[Long Term Due], qryIncidentDetails.[Long Term Completed], qryIncidentDetails.Verification, qryIncidentDetails.Verifier, qryIncidentDetails.[Verification Date], qryIncidentDetails.[Closed/Open], qryIncidentDetails.Injured, qryIncidentDetails.Comments, qryIncidentDetails.Keyword2, qryIncidentDetails.Keyword1, qryIncidentDetails.[Keyword 1], qryIncidentDetails.[Keyword 2], qryIncidentDetails.[Incident Time], qryIncidentDetails.Witness, qryIncidentDetails.[Entry Date], qryIncidentDetails.Summary, qryIncidentDetails.[Project Manager], qryIncidentDetails.Photos, qryIncidentDetails.Investigation
FROM qryIncidentDetails
WHERE (((qryIncidentDetails.[Job No]) Like [Enter Job No]) AND ((qryIncidentDetails.[Incident Date]) Between [Enter From Date] And [Enter To Date]))
ORDER BY qryIncidentDetails.[Incident Date];
The query and subsequent report run fine if a project number, start date and end date are entered. The query will also run if the project number is wildcarded (*) with the start and end dates entered.