Query with multiple date range constraints.

[younggunnaz69]

Hi All

I was hoping I could get help with a query that has been bothering me for awhile. I have tables that I have pasted sample data for below. tblVisit has the Date range where we have to visit a Property. tblBlackout has a Date Range where we can not visit the property. I would like to enter a Start Date and End Date in a form, lets say Forms![FormName]![SDate] and Forms![FormName]![EDate] and have it show all properties that can be visited in that range. Your help is much appreciated!!



tblVisit

PropID | StartWindow | EndWindow
1 | 02/01/2012 | 03/21/2012
2 | 01/01/2012 | 01/20/2012
3 | 01/15/2012 | 02/15/2012

tblBlackout

PropID | StartBlackout | EndBlackout
1 | 01/01/2012 | 01/15/2012
2 | 01/15/2012 | 02/15/2012
3 | 02/01/2012 | 03/01/2012

[orange]

What have you tried? What result?

[younggunnaz69]

I tried to apply my scenerio to this one(not sure if they are the same) ( http://www.artfulsoftware.com/infotr...es.php#98) but could not get it to work. Thanks again to anyone who can help!