Between function

[brownk]

Hi guys. I have a query that runs a report. In the 'Date' section i have my criteria set to 'Between [start date] and [end date]' so whenever the report is ran, the user has the option of viewing entries for a specified date. Is there anyway to set it up so if the user decides to just hit cancel when called to enter a start and end date, it will simply display ALL entries on the report? I know, I know, the user can just put in something like start date 1-1-1111 end date 1-1-2050; but i have been asked by my boss to try and get this hammered out. Any help will be appreciated. Thanks!

[JoeM]

Try this:
Between NZ([start date],#1/1/1900#) and NZ([end date],#12/31/2099#)

[brownk]

Thanks. Works great and is exactly what i was looking for!