Hi,
I have a database containing a schedule for employee's jobs. Each job has a start date/time and end date/time. Some jobs can spread over days or weeks.
I want to create a query where I can bring up all jobs for that day, so this may not mean just by start date as the start date may be for the previous day for example but I still want to see the jobs due to be worked that day.
Could someone help?
Many Thanks