Date Range - text box on form

M

Mary

I have two unbound text boxes on a form to enter a start date and end date.
In my query, I can refer to these controls and have the report pull that
range. What I'd like to be able to do is have the default be all of the
records, but if those controls have values, then restrict it that range. Is
this possible?
Thanks, Mary
 
A

Allen Browne

Mary, see:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

If you use Method 2 in the article, it works like this:
* both start and end dates found: filtered between those dates;
* only a start date found: records from that date onwards;
* only an end date found: records up to that date only;
* neither start nor end date found: all records included.
 
Top