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
Code:
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
Code:
PropID | StartBlackout | EndBlackout
1 | 01/01/2012 | 01/15/2012
2 | 01/15/2012 | 02/15/2012
3 | 02/01/2012 | 03/01/2012