Date Range Query

[FMezler]

I am looking to create a query that would display information based on Start and End Dates. For example, one Start Date would be 5/13/2002 with an End Date of 5/17/2002. I would want that record displayed on 5/13/2002, but not after 5/17/2002. There could be another record in the table with a Start Date of 5/14/2002 and an End Date of 5/17/2002. That record should be displayed starting 5/14/2002 and I would still want the 5/13/2002 displayed because it is not due to end until 5/17/2002. I figure I cant use BETWEEN because that would include some records that are before their Start Date. Any way to do this?

 

[cmmrfrds]

Start Date >= 5/13/2002 and End Date <= 5/17/2002

 

[FMezler]

The only problem with that code is that it would include 5/14/2002 on 5/13/2002 because the 14th falls between the 13th and 17th. I would not want the 14th to be displayed until it was the 14th. End dates could possibly be different also. One might have a one day difference while another might have a 5 day difference. Thats the problem I am running into. How to get Access to evaluate two dates based on the current date.