Date Range Options - picking up null dates as well.

[jamjarr]

Hello Everyone

I need some help on completing a date range option on a report. I have been reading other posts about date ranges. I have got the usual Between option in the query and that works OK. However I have some records with Null values in the field and I need to pick them up as well.

I hope someone can help.

Thanks is advance.

 

[RichO]

How about:

Between #1/1/05# and #5/5/05# or Is Null