Sickness Days

[Elmobram22]

Hi all,

I'm making a database that pulls data from a CSV file downloaded from a website. The data holds information on which staff member has logged in or out at work. My database analyses this and tells us when staff have done a sleep in shift and subtracts breaks based on clocking in hours. If a person is sick or on leave they do not get paid for the sleep in. If they are on leave they get paid for the hours (not the sleep in). What I am now trying to do is add in that if people are on sick they do not get paid for the first three (consecutive) and then get paid half pay from then on for up to 6 months. I have attached the database with some sample data in it. I have no idea where to start on making this work. Any help would me greatly appreciated.

Cheers,

Paul

 

[Elmobram22]

I should say this needs to happen in the query QryDeductionsandSleep Ins.

 

[JHB]

Maybe you should show the result you want, from the data in your attached database!

 

[Elmobram22]

I would want it the notes column says sick that it removes the pay. But if it says sick for the same staff member for over 3 days that it divides the full pay by half.

Cheers