P
PatrickA
All,
I can't find info on how to do this in Access Help, and am hoping it
can be done...
I have a query with the following in the Criteria field for my Export
Date:
How do I enhance this Criteria so that
If the user does not enter a Starting Export Date, the query retrieves
all records back to 5/1/2009.
If the user does not enter an Ending Export Date, the query retrieves
all records forward to the latest record after 5/1/2009.
If the user enters neither a Starting Export Date or an Ending Export
Date, the query retrieves all records from 5/1/2009 to the latest
record.
I've tried using "*", but did find info that that will not work with
Between.
Thanks!
Patrick
I can't find info on how to do this in Access Help, and am hoping it
can be done...
I have a query with the following in the Criteria field for my Export
Date:
=#5/1/2009# And Between [Enter a Starting Export Date] And [Enter an Ending Export Date]
How do I enhance this Criteria so that
If the user does not enter a Starting Export Date, the query retrieves
all records back to 5/1/2009.
If the user does not enter an Ending Export Date, the query retrieves
all records forward to the latest record after 5/1/2009.
If the user enters neither a Starting Export Date or an Ending Export
Date, the query retrieves all records from 5/1/2009 to the latest
record.
I've tried using "*", but did find info that that will not work with
Between.
Thanks!
Patrick