Prompt for Date or Enter for All in a Query

[fenhow]

Hi,

Simple query with dates, I am tying to figure out how to when the query is run prompt the user for a date he wants the query to run on or select enter for all dates.

Is this possible?

Thanks.
Fen How

 

[pbaldy]

One way:

http://www.mvps.org/access/queries/qry0001.htm