Query between dates

[eacollie]

I have a [StartDate] and[EndDate] and I want to select any records that fall between these two dates. If I select [StartDate] >= date1 and [EndDate] <= date2, I don't get the records that have a start date BEFORE the date1 but occurred during this date range.

How do I write the query for this?

Thank you!

 

[Ranman256]

If the dates are in text boxes on the form,

Select * from table where forms!myForm!txtDate1 >= [startDate] and forms!myForm!txtDate2 <= [endDate]

 

[eacollie]

Thank you. That gives me anything starting after that date. I want to select anything happening BETWEEN those dates.

For example:
[StartDate] = 1/1/2018 and [End Date] = 1/6/2018

If I select anything starting 1/2/2018 I don't get the above included in the result.

 

[jdraw]

see this re Overlap dates from PBaldy

Can you give us some sample data and also show us what this(anything) means exactly with your sample?

I want to select anything happening BETWEEN those dates.

 

[eacollie]

Thank you jdraw! That's EXACTLY what I was looking for. (And thank you PBaldy).

 

[jdraw]

You're welcome - Paul Baldy and I are happy to help.
Good luck.