Query to return before a date or if the date field is null

[charlesk]

Greetings,

I am trying to create a query that will return records that are before a date (input by user) or if the date field is empty. This is what I have tried and it works great except that it doesn't return the empty date records.

(<=[Enter End Date:]) Or (IsNull(""))

Any assistance is greatly appreciated.

[pbaldy]

Shot in the dark, but try

<=[Enter End Date:] Or Is Null

[humanexhaust]

Im assuming you are trying to use the Query Design View. Try passing the variable through the IsNull function like below.


Your example should look like: (<=[Enter End Date:]) Or (IsNull([Enter End Date:]))

Or..

Use the criteria as suggested below.



Im not going off of much description here but I hope this helps. I could also give you the VBA If statement if you require that route.