I have a Access database attached to my Vb prog it has names and dates of when people are off work and the date they come back to work.

I have the SQL to search the name and the date when they go off work but I wouldnt know where to start to show if they are off work between that date and the date they return from holiday.


Any one any Idea how I do this?


thx