finding if a period falls within a period in access 2000

M

Michel Walsh

Hi,


[a1, b1] does not overlap [a2, b2] if and only if

a1> b2 OR b1 <a2


There is some overlap (barely touching, partial overlap, or complete
inclusion) in the negative (use DeMorgan's Law):

a1 <= b2 AND b1>= a2




Hoping it may help,
Vanderghast, Access MVP
 
Top