Hi All,
I've been tasked with reporting on the Holiday / Sickness within my company.
I have a quick question.
I have a calendar with all dates for x years.
The sickness data I have is just a start and end date. I need to break this down into how many days per month.
With a query, how would I set it to amend all days between the start and end date as off sick.
This would be data imported from an Excel sheet.
I've been tasked with reporting on the Holiday / Sickness within my company.
I have a quick question.
I have a calendar with all dates for x years.
The sickness data I have is just a start and end date. I need to break this down into how many days per month.
With a query, how would I set it to amend all days between the start and end date as off sick.
This would be data imported from an Excel sheet.