Nowsherwan
New member
- Local time
- Yesterday, 23:40
- Joined
- Jun 16, 2008
- Messages
- 5
Hy All!
I am new to access i would like to mantain an emloyees earned leave record..
The Scenrio is: Every employee credit two earned leave for each month from the date of joining to the current date, two leave will be credited exactly at the Month end, but if the joining date is greater then the 15th of that month then no leave will be credited for the specific month...
How do i calculate the months between two dates i.e Joining date & current date..?
How do i credit the two leave to every employee after the each month..?
How i restrict the system to can't credit the leave if the joining date is greater then the 15th of that month..?
Despretely witing to your's replay...
Thanks in Advance
I am new to access i would like to mantain an emloyees earned leave record..
The Scenrio is: Every employee credit two earned leave for each month from the date of joining to the current date, two leave will be credited exactly at the Month end, but if the joining date is greater then the 15th of that month then no leave will be credited for the specific month...
How do i calculate the months between two dates i.e Joining date & current date..?
How do i credit the two leave to every employee after the each month..?
How i restrict the system to can't credit the leave if the joining date is greater then the 15th of that month..?
Despretely witing to your's replay...
Thanks in Advance
