Exteacting records on date criteria

[make me rain]

with vb.net + access03

the table is like this
employeename
leavetype
fromdate
todate

i want to extract the records basing on date criteria say for eg:- fromdate is between 01/02/10 and 10/02/10
query works fine but
what if a employee is on leave from 31/01/10 to 11/02/10 query won't return this record at all

actually in the specified period the employee having 10 days of leave from 01/02/10 to 10/02/10

in such kind of situations how to extract the leave period of an employee
any guidance please

[brucevde]

Both the FromDate and ToDate would need to be used in the criteria.

To find employees on leave within a given date range

Where FromDate <= EndofDateRange And ToDate >= StartofDateRange

[GaryMazzone]

If you are not using parameters the dates need to be in either US Standard (mm/dd/yyyy) or ANSI standard (yyyymmdd)