>
> Here's how I usually write my WHERE clauses for scheduling:
>
> ((ScheduleStart < UserStart) and (ScheduleEnd > UserEnd))
> OR (ScheduleStart BETWEEN UserStart and UserEnd)
> OR (ScheduleEnd BETWEEN UserStart and UserEnd)
>
> Hope this helps.
>

I will give it a try Daniel.

Thank you,

Lee