Date Range Crossover

[ReAn]

Trying to pull up records that have any scheduled day/time in another range of date/times.

Ok:

In my Table i have Scheduled Start and Scheduled Finish, and on my form i have Period Beginning and Period Ending. I need to pull up any records that are scheduled to be active between Preriod Beginning and Preiod End

Any suggestions?

 

[pbaldy]

ScheduledStart <= PeriodEnding AND ScheduledFinish >= PeriodBeginning

 

[ReAn]

What if they overlap? Like, this:

Daterange1:__||||||||||||||||____
Daterange2:________||||||||||||||

 

[pbaldy]

Did you test it? It should include those records, as they are active during the period (which is what you wanted, right?).