I have a report based on a query which has 2 date columns '[DATE IN]' & '[DATE OUT]'.
I want to run report and pick all rows which has no entry in [DATE OUT] or [DATE OUT] is between two dates selected from userform.
I have setup variables startdate and enddate to the range of dates selected on userform. Running following produces the rows which has [DATE OUT] within range, and is correct
DoCmd.OpenReport "Movement", acViewReport, , "[DATE OUT] " & "Between #" & startdate & " # AND #" & enddate & "#"
I want to also pick row which doesn't have an entry in [DATE OUT].
I as assuming [DATE OUT] will be NULL ( or "" ?)
How can I modify the OpenReport to include rows with no date in [DATE OUT] field ?