Another Date Query

[Please help James]

Does anyone know how to add a third option to a date query? I know how to do
a date range query, however, I would like to have a third option "all" so
that a user has the option to view all records ragardless of the date range.
Thanks!

 

[fredg]

Does anyone know how to add a third option to a date query? I know how to do
a date range query, however, I would like to have a third option "all" so
that a user has the option to view all records ragardless of the date range.
Thanks!

And what is your criteria using just a date range?

Where YourDate between [Enter Start Date] and [Enter End Date] or
[Enter Start Date] is null

Leave [Enter Start Date] empty when prompted to get all records

 

[Please help James]

Fred, I was entering the critiria at the query level...is that not correct?

Does anyone know how to add a third option to a date query? I know how to do
a date range query, however, I would like to have a third option "all" so
that a user has the option to view all records ragardless of the date range.
Thanks!

And what is your criteria using just a date range?

Where YourDate between [Enter Start Date] and [Enter End Date] or
[Enter Start Date] is null

Leave [Enter Start Date] empty when prompted to get all records