Between dates

[jamesb]

In this database I am working on, I would like to select a set of dates for
the query to search on based on, unbound text boxes I have placed in a form.
The defaults are set for our fiscal year, but I want people to be able to
type in their own set of dates if they don't want the whole year. Question
is...what is the expression that gets typed into the query? I have Start Date
and End date for the 2 field names. I tried a couple things and can't get
it...and am not sure what I am missing or if it can't be done at all.

Thanks
JB

 

[Allen Browne]

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

The first method explains how to set up the parameters in the query, and
declare them so that Access understands them as dates.

 

[Allen Browne]

I should also have explained to use parameter names like this:
Between [Forms].[Form1].[StartDate] And [Forms].[Form1].[EndDate]

Also, set the Format property of these unbound text boxes to General Date or
similar (again, to ensure Access interprets them correctly, and block
invalid dates.)