Problems with date range query. Please Help.

[Candles]

Hi I am creating a query based on a date range. I am currently using Between .... And however this isn't producing the right result.

I have 2 parameters (Start Date, End Date) for the date range but I want the result to return the records so that if a start date is before the specified start date but the record extends into the date range or after the date range it will still get pulled out.

Any ideas??

Thanks, Tasch

 

[THoey]

You are going to need to use the OR clause:

WHERE MyTable.StartDate BETWEEN StartParameter AND EndParameter OR
MyTable.EndDate BETWEEN StartParameter AND EndParameter

Hope that helps... Terry M. Hoey