Access Query Help - Challenge

[J P Singh]

Hi All

Please help me in solving this tricky problem.

We have an access database. In one of the tables we store the days the
employees have booked as holidays.

The table structure is like this

EmpNumber
DateFrom
DateTo
NoofDays
(the above table is related to the employee profile table which stores the
empnumber, firstname , lastname , department etc and the two tables are
related by empnumber field)

I want to run a query which will give me a list of all employees who have
not booked the holidays between 29th Dec to 31st dec.

We need this as it is company policy that 29th -31st dec has to booked as
compulsory days off.

Can this be done.

Thanks

 

[Douglas J. Steele]

One approach (not necessarily the best) would be to have a query that
returns all of those employees who ARE taking holidays between 29th Dec and
31st Dec.

Then, have a second query that determines all the employees that aren't in
that list.