Good afternoon and Jose and Murdo here with our MS Access database fun for Christmas! What we'd like to know is there an easy way to find out which of our employees are here for the 25th December and the only data we have is linked to our Leave Status Sheet in attached. Does anyone have ideas and not just for the Christmas Day, but any other selected day of the year? Kind regards as always, Murdo

Which fields are you pulling in from your leave status sheet?

If you track the date that a person arrives and a person leaves, you can see if the arrival date is before Christmas and the departure date is after Christmas.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.