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

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 - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"jamesb" <(E-Mail Removed)> wrote in message
news:5E183894-F285-4717-8EA6-(E-Mail Removed)...
> 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

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.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"jamesb" <(E-Mail Removed)> wrote in message
news:5E183894-F285-4717-8EA6-(E-Mail Removed)...
> 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.