Georgenetwork
Registered User.
- Local time
- Yesterday, 19:33
- Joined
- Nov 1, 2019
- Messages
- 21
Access Help!
Here are my fields for the subform
Table2
EmployeeID
Firstname
LastName
Date of Birth
Table2
ID
EmployeeID
LeaveType (lookup) Annual Leave, Sick Leave
StartDate
EndDate
Annual Leave limit 20days
Sick Leave Limit 10days
The leave windows start from january and ends December. The leave process is flexible to the extend Employee John can take 5 days
of leave in January, then take 10 in September and than 5 in December. How do i sum it up? How do I prevent such employee from taking more than the 20 days when he take his
leave in pieces?
How do i limit Annual Leave to not more than 20 working days and Sick Leave 10 days
Please help
Here are my fields for the subform
Table2
EmployeeID
Firstname
LastName
Date of Birth
Table2
ID
EmployeeID
LeaveType (lookup) Annual Leave, Sick Leave
StartDate
EndDate
Annual Leave limit 20days
Sick Leave Limit 10days
The leave windows start from january and ends December. The leave process is flexible to the extend Employee John can take 5 days
of leave in January, then take 10 in September and than 5 in December. How do i sum it up? How do I prevent such employee from taking more than the 20 days when he take his
leave in pieces?
How do i limit Annual Leave to not more than 20 working days and Sick Leave 10 days
Please help