Ù
ياسر
I work in company that takes 2 days for weekend it's Friday and Saturday
and all the holidays that may be more than one day such as Eid El Adha
is more than 3 days continuously.
So i made a form for entering the vacation for each employee in the company
like the following :
the main form :
Emp name , Department , and then the sub form like the following:
Date from , Period , Date to , kind of vacation
So how to calculate the vacations days for the emp without counting any of
the weekend days or holidays that's may me more than 3 or 4 days as i said
before.
like : emp takes 10 days vacation from 1/12/2008 To 10/12/2008 so there is
Friday and Saturday counted i don't want them to be counted so the condition
is that the Emp vacation is to be ended in 12/12/2008 or if there is any
other holidays in between the vacation for the Employee
The Rules for the calculation statement:
every employee has an account limit for the vacation its 21 days for
whom have experience for 1 year To 10 years for the current year OR 30 days
for whom that have experience more than 10 years or more every current year
So I need to calculate the days that he toke throw the current year as i
wrote before .
is there any way to do by using the form with sub form that i made above
main form contains the information for the Employee
sub form contains the processing for the vacations details
date from - period - date to - kind of the vacation
and all the holidays that may be more than one day such as Eid El Adha
is more than 3 days continuously.
So i made a form for entering the vacation for each employee in the company
like the following :
the main form :
Emp name , Department , and then the sub form like the following:
Date from , Period , Date to , kind of vacation
So how to calculate the vacations days for the emp without counting any of
the weekend days or holidays that's may me more than 3 or 4 days as i said
before.
like : emp takes 10 days vacation from 1/12/2008 To 10/12/2008 so there is
Friday and Saturday counted i don't want them to be counted so the condition
is that the Emp vacation is to be ended in 12/12/2008 or if there is any
other holidays in between the vacation for the Employee
The Rules for the calculation statement:
every employee has an account limit for the vacation its 21 days for
whom have experience for 1 year To 10 years for the current year OR 30 days
for whom that have experience more than 10 years or more every current year
So I need to calculate the days that he toke throw the current year as i
wrote before .
is there any way to do by using the form with sub form that i made above
main form contains the information for the Employee
sub form contains the processing for the vacations details
date from - period - date to - kind of the vacation