linking a table with a date range to a table with individual dates

[dubstop]

I have two tables, one is data from a time and attendance system and shows when an employee clocked in and out, there is also a boolean showing if they were absent on a given dates.
My problem is that I need to only show it as an absence in the dataset if they didn't have a holiday booked for that day, the holiday booking table stores a date from and date to for a booking and I have been unable to come up with a query that will link this range and the individual dates

Clockings table has fields:
EmpNo, shiftdate, ABS
Holiday table has fields:
EmpNo, DateFrom, DateTo

I would appreciate any help on this

 

[PHV]

query that will link this range and the individual dates
Perhaps something like this ?
SELECT C.EmpNo, C.shiftdate, C.ABS, H.DateFrom, H.DateTo
FROM [Clockings table] AS C
INNER JOIN [Holiday table] AS H ON C.shiftdate Between H.DateFrom And H.DateTo

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dubstop]

Thank you, that seems to work although it is a little slow, I shall add an index or two and see if that helps!