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 said: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
Fred, I was entering the critiria at the query level...is that not correct?
fredg said: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
fredg said:Fred, I was entering the critiria at the query level...is that not correct?
fredg said:On Tue, 20 Feb 2007 12:20:20 -0800, Please help James wrote:
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
That's where it goes.
I was referring to what your actual prompt was,.....
[What does it say inside the brackets].