Between Dates Or ALL Dates query

[eti3nne]

How would I construct a query that allows for parameters of start and end date (eg a between start and end expression - such as ... Between [Enter Start Month as mmm yyyy] And [Enter End Month as mmm yyyy]) that ALSO allows for entering of * to select ALL dates?

Thanks for looking.

 

[M8KWR]

what you can do is enter this in the query in the date field

>=IIf(IsNull([start date]),#01/01/75#,[start date]) And <=IIf(IsNull([end date]),#01/01/25#,[end date])

You can alter the default start and end dates if you wish.

Any issues let me know. You could use text boxes on a form if you wished. If you are unsure how to alter the code to do this let me know and i can show you how.