How to Compare Two Date Ranges?

[Jaynen]

Hello



I have a table with employee names and there start time and stop time for their shift. There is also a start time and stop time which they cant work during their shift. So I have shiftstarttime and shiftstoptime and codestarttime and codestop time. I have to create a table with the employee names and generate a time called outboundtime. This outboundtime starts at a specified time (e.g. 9am) and runs for a specified time (60mins). This outboundtime has to be within the range of the employees shift and cant be within the range of the cant work time. If it was, then it would start after the codestoptime for that employee.

Is anyone able to help me come out with a way to program this. I have been trying "if then statements" but I can't seem to compare a range of time to another range of time. Only a specified time to a range which is making things confusing.

I would greatly appreciate any help! Thanks.

[Jaynen]

Anyone? Am I just missing something and making this out to be way to hard? I am beginner level at access so anything would be helpful. Thanks.