I'm working on a database that records peoples holiday leave. I want to create a query, where I can ask the database who on holiday in a particular Month, or between two stated dates (i'll need two queries I think). My colums have two date sources: Start Date, End Date.
I've tried using the Between And Function, but it misses people who are Start their holiday before the Between date, but finish before the And date ( i hope that makes sense).
Is there anyway of capturing this info?
If possible, I'd like a query that askes for a specific Month, so that if someones leave falls within that month, it will capture it also. Is this possible?