Query by range between start and end date?

[rmulder]

ok, so i am working on a database to track vacation/time off for my employees. Ive got "time off" records with a start and end date, as well as start and end times. My questions is, If I want to see just the time off records that falls between say 5/27 thru 5/30. How do I go about this?

I ask because say someone has 5/24 - 6/1 off. The start and end dates are outside the range i'm looking at but that person IS still on vacation those days....

Thanks for any and all help!

 

[boblarson]

See if this helps:

http://www.baldyweb.com/OverLap.htm

 

[rmulder]

That was perfect, just what I needed! Thanks!