Problems with Date Range in query

[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

 

[nhtraven]

I use this on my date range queries

I add date field twice
in first date field i put in criteria [Enter start date]
in second date field <expr1 is title i think>
i hide the field
then put in [Enter End date] in that criteria
It seems to have worked for me. Not sure if tha is what your looking for

Raven

 

[Candles]

No, I have both a Start Date and an End Date in the database but I want to return all records that include a date in the specified range.

Tasch...

 

[THoey]

I answered this in one of the other Access forums... Terry M. Hoey