Help in access issue - calculated field for Leave system

[mike60smart]

thanks for your reply,

about first question its 30 days per year but also i want to make calculation for that regarding "Joining Date"
Like example the contract started 01-Jan-2020 the contract ends 31-DEC-2023 that means if there is employee joined 01-Jan-2023 it automatically calculated in Balance Record "30" and the next record show "from 1st Year"

if another employee joined 01-Jul-2021 it calculated automatically "15" and the next record show "from 2nd Year"

the problem is how to make this place updated not to be added new record. and only type "Annual" is required for calculation fridays and holidays.

If Employee joins Contract in 1st Year Leave entitlement is 30 days
If Employee joins Contract in 2nd Year Entitlement is 15 days
what entitlement does an employee get for 3rd and 4th Years ??

This looks a bit odd to me.

 

[Eugene-LS]

want to know where i should put this code: in the form or in the query ?? to make it works automatically when i work

See to Query " frmLeave_SubForm_Details" as example:

SELECT [Leave Dates].*,
    GetDaysEFH([Start_Date],[End_Date]) AS DaysEFH,
    [Days]-GetDaysEFH([Start_Date],[End_Date]) AS EFH_Difference
FROM [Leave Dates];

Try change some dates ([Start_Date] and [End_Date]) in query ...

 

[Gasman]

If Employee joins Contract in 1st Year Leave entitlement is 30 days
If Employee joins Contract in 2nd Year Entitlement is 15 days
what entitlement does an employee get for 3rd and 4th Years ??

This looks a bit odd to me.

I read that as just 15 days as they joined in July?, hence half the leave entitlement?

 

[arnelgp]

you may also try this.