Between Clause

[Question Boy]

Hello,

I have a query with numerous fields (geez I'm sure that was insightful!). 1
field is entitled 'Start Date' and another is 'End Date'.

I also have a form 'frm_dtSel' which has a control 'cbo_yearSel' from which
the user can select a year value (ie: 2007, 2008, 2009,...). I need to use
the selected value from the form to filter the returned values from the query
so that the selected year must be between the Start and End date. How would
I need to write the SQL to do so?

Thank you very much for the help!

QB

 

[strive4peace]

do you mean that the start and end date must both be in the selected year?

on the grid:

field --> YrStart: Year([StartDate])
citeria --> forms!formname!controlname
(ie: forms!frm_dtSel!bo_yearSel)

and the same for your end date

~~~

if you mean you want the start date to be BEFORE the year, use
< forms!formname!controlname
for the criteria for year of the start date




Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*