I have an application that needs to determine crew members who were on between certain dates. I have two data fields named [SignOn] and [SignOff]. I have a criteria field in my query that gets its date from a textbox on a form txtReportDate. My WHERE Statement is as follows;
This works great EXCEPT when I have to deal with a Null Sign Off value. I have tried Using OR Is Null with [SignOff] But then this disregards my criteria for SignOn and just returns all records.Code:WHERE ((([Forms]![frmVesselReport]![txtReportDate]) Between [SignOn] And [SignOff]))
What am I missing here? I have racked my brains out trying to make this work. I simply want to return all records BETWEEN [SignOn] and [SignOff] and to also include those with Null values for [SignOff] if they exist. Nothing I have tried has returned the desired results.