Querying dates between a start and end date field

[WatsonDyar]

I have a db tracking vacation times for staff. One of the fields tracks a members vacation start and end dates. I need a way to pull a report to see who is on vacation based on Date() (today). Is this possible?

For example:

A record for John Doe has him start vacation 08/19/2014 and end vacation on 8/28/2014. If I wanted a report that shows who is on vacation today, 08/25/2014, using the date() function), how would I do this?

Thanks!

 

[CJ_London]

try

SELECT *
FROM myTable
WHERE Date() BETWEEN VacationStart AND VacationEnd

 

[pbaldy]

If you end up needing to query a range:

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

 

[WatsonDyar]

Thank you CJ & pbaldy! I'm going to check these out....looks like exactly what I'm looking for.