query for records between two dates

[blogmk]

hi,

I need help with access query.


Only one table : Customer ID,Customer name , subscription period, subscription start date and subscription end date.

I need values where subscription start date is between date1 and date2
and
subscription end date is between date 1 and date2.

Detail explanation:

customer1 subscribed from 2-feb 2012 to 2-feb 2013
customer2 subscribed from 5-aug-2012 to 5-aug-2013
customer3 subscribed from 1-Jan-2013 to 31-Dec-2013
when the user enters date 1 as 1-jan-2013 and date 2 as 30-Jun-2013

Even though the subscription start date is not within the range entered by the user.I need to get all three customers because the subscription enddate falls within the range.
And customer 3 is also required as subscription start date is within the range.
Please help

 

[Alansidman]

Use the Between function in your criteria for both fields, but put the criteria on two separate lines. In this manner you have created an or criteria. Look at this link for further information on the Between function.

http://www.w3schools.com/sql/sql_between.asp

 

[blogmk]

Thanks Alan,

created an or criteria and it worked fine.Thanks