Solved Sickness Query

[Eureka99]

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.

 

[ebs17]

Like this

SELECT
   D.Person_ID,
   C.calDay
FROM
   tblData AS D,
   tblCalendar AS C
WHERE
   C.calDay BETWEEN D.DateStart
      AND
   D.DateEnd

 

[Eureka99]

Many Thanks