TriciaLatchman
Registered User.
- Local time
- Today, 15:37
- Joined
- Jul 24, 2017
- Messages
- 13
Hi Guys,
I am trying to create a database that track annual leaves for employees by entitlements.
I have created a table named tblType_of_Leave with the following fields
(PK) LeaveTypeCode = AutoNumber
LeaveTypeDescription=Short Text
Days Entitled=Number
Leave Type Days Entitled
Vacation Leave 20 Days for 1-Year Contract
40 Days for 2-Year Contract
60 Days for 3-Year Contract
0 Days for Month to Month
0 Days for Probation
Personal Leave 7 Days for 1-Year Contract
7 Days for 2-Year Contract per Contract Year
7 Days for 3-Year Contract per Contract Year
0 Days for Month to Month
0 Days for Probation
Sick Leave 14 Days for 1-Year Contract
14 Days for 2-Year Contract per Contract Year
14 Days for 3-Year Contract per Contract Year
0 Days for Month to Month
0 Days for Probation
Maternity Leave 70 Days for 1-Year Contract
70 Days for 2-Year Contract per Contract Year
70 Days for 3-Year Contract per Contract Year
0 Days for Month to Month
0 Days for Probation
Paternity Leave 2 Days for 1-Year Contract
2 Days for 2-Year Contract per Contract Year
2 Days for 3-Year Contract per Contract Year
0 Days for Month to Month
0 Days for Probation
Compassionate Leave 3 Days for 1-Year Contract
3 Days for 2-Year Contract per Contract Year
3 Days for 3-Year Contract per Contract Year
3 Days for Month to Month
3 Days for Probation
No Pay Leave 0 Days
How do i setup table to calcuate Entilement base on infor above?
Table Contact Term are as follow:
PK ID AutoNumber
Contract Term Short Text
ID ContractTerm
1 1-Year
2 2-Years
3 3-Years
4 Month-to-Month
5 Probation
I am relatively new to Access an really need some advice.
Requirements:
Form to select employee from tblEmployee
select LeaveType Taken from tblType_of_Leave
enter number of Days Taken
Report to show List of Employees with their LeaveType,
Entitlements (Days) for each Leave Type,
Number of Days Taken for each Leave Type,
And Balance of Days for each Leave Type,
I am trying to create a database that track annual leaves for employees by entitlements.
I have created a table named tblType_of_Leave with the following fields
(PK) LeaveTypeCode = AutoNumber
LeaveTypeDescription=Short Text
Days Entitled=Number
Leave Type Days Entitled
Vacation Leave 20 Days for 1-Year Contract
40 Days for 2-Year Contract
60 Days for 3-Year Contract
0 Days for Month to Month
0 Days for Probation
Personal Leave 7 Days for 1-Year Contract
7 Days for 2-Year Contract per Contract Year
7 Days for 3-Year Contract per Contract Year
0 Days for Month to Month
0 Days for Probation
Sick Leave 14 Days for 1-Year Contract
14 Days for 2-Year Contract per Contract Year
14 Days for 3-Year Contract per Contract Year
0 Days for Month to Month
0 Days for Probation
Maternity Leave 70 Days for 1-Year Contract
70 Days for 2-Year Contract per Contract Year
70 Days for 3-Year Contract per Contract Year
0 Days for Month to Month
0 Days for Probation
Paternity Leave 2 Days for 1-Year Contract
2 Days for 2-Year Contract per Contract Year
2 Days for 3-Year Contract per Contract Year
0 Days for Month to Month
0 Days for Probation
Compassionate Leave 3 Days for 1-Year Contract
3 Days for 2-Year Contract per Contract Year
3 Days for 3-Year Contract per Contract Year
3 Days for Month to Month
3 Days for Probation
No Pay Leave 0 Days
How do i setup table to calcuate Entilement base on infor above?
Table Contact Term are as follow:
PK ID AutoNumber
Contract Term Short Text
ID ContractTerm
1 1-Year
2 2-Years
3 3-Years
4 Month-to-Month
5 Probation
I am relatively new to Access an really need some advice.
Requirements:
Form to select employee from tblEmployee
select LeaveType Taken from tblType_of_Leave
enter number of Days Taken
Report to show List of Employees with their LeaveType,
Entitlements (Days) for each Leave Type,
Number of Days Taken for each Leave Type,
And Balance of Days for each Leave Type,