Date range parameters

A

Al Camp

In a query, in a date field, I have the following
parameter/criteria...
Between [Enter Start Date] And [Enter End Date]

I'd like to offer the user the option of entering a date range to
limit
the resulting records,
OR... enter nothing in response to the parameters, and get ALL
dates returned.

In this non-date example...
Like [Enter Customer Name] & "*"
the user can just hit the ENTER key, and all Customer Names will
be displayed.

Can I do the same for my DATE parameters??

Thanks,
Al Campagna
 
R

Rick B

Use an IF statement. Something like...

IIF Enter Start Date not null and Enter End Date not null then between start
and end, otherwise, show all.

Rick B


In a query, in a date field, I have the following
parameter/criteria...
Between [Enter Start Date] And [Enter End Date]

I'd like to offer the user the option of entering a date range to
limit
the resulting records,
OR... enter nothing in response to the parameters, and get ALL
dates returned.

In this non-date example...
Like [Enter Customer Name] & "*"
the user can just hit the ENTER key, and all Customer Names will
be displayed.

Can I do the same for my DATE parameters??

Thanks,
Al Campagna
 
F

fredg

In a query, in a date field, I have the following
parameter/criteria...
Between [Enter Start Date] And [Enter End Date]

I'd like to offer the user the option of entering a date range to
limit
the resulting records,
OR... enter nothing in response to the parameters, and get ALL
dates returned.

In this non-date example...
Like [Enter Customer Name] & "*"
the user can just hit the ENTER key, and all Customer Names will
be displayed.

Can I do the same for my DATE parameters??

Thanks,
Al Campagna
Click to expand...

Try it like this:

WHERE YourTable.DateField Between [EnterStart] And [EnterEnd] OR
YourTable.DateField) Like IIf(IsNull([EnterStart]),"*");
 
A

Al Camp

Fred,
Just the ticket!!
Thanks a lot,
Al Campagna

fredg said:
In a query, in a date field, I have the following
parameter/criteria...
Between [Enter Start Date] And [Enter End Date]

I'd like to offer the user the option of entering a date range to
limit
the resulting records,
OR... enter nothing in response to the parameters, and get ALL
dates returned.

In this non-date example...
Like [Enter Customer Name] & "*"
the user can just hit the ENTER key, and all Customer Names will
be displayed.

Can I do the same for my DATE parameters??

Thanks,
Al Campagna
Click to expand...

Try it like this:

WHERE YourTable.DateField Between [EnterStart] And [EnterEnd] OR
YourTable.DateField) Like IIf(IsNull([EnterStart]),"*");
Click to expand...
 
Top