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