SetanPutih
Registered User.
- Local time
- Today, 04:45
- Joined
- Jun 27, 2019
- Messages
- 27
Hi guys,
I need some help please. OK so..
I am creating an annual leave app for my company. I have two tables with different functions. The purpose of the first table is to record annual leave which has been applied for. The fields are..
ID
Employee ID
Holiday year
Branch
First Date Absent
Last Date Absent
The second table keeps a running total of how many annual days each employee has remaining. The number is linked to the name e.g. James, 25.. Once I input the Number of Days Requested it reduces it from the running total. Therefore the table does not create new records, it only modifies the number linked to the name. The fields are..
Employee ID
Employee name
Number Of Days Accrued
Number of Days Requested
Currently, to input an annual leave, both tables are presented in a Form and subform which records the information in two separate tables.
What I'm trying to do is create a report which shows the information from both tables. Unfortunately, due to the clash in functions I don't know how this would be possible.
Does any one have any ideas?
Thank you for taking the time to read this.
Employer
I need some help please. OK so..
I am creating an annual leave app for my company. I have two tables with different functions. The purpose of the first table is to record annual leave which has been applied for. The fields are..
ID
Employee ID
Holiday year
Branch
First Date Absent
Last Date Absent
The second table keeps a running total of how many annual days each employee has remaining. The number is linked to the name e.g. James, 25.. Once I input the Number of Days Requested it reduces it from the running total. Therefore the table does not create new records, it only modifies the number linked to the name. The fields are..
Employee ID
Employee name
Number Of Days Accrued
Number of Days Requested
Currently, to input an annual leave, both tables are presented in a Form and subform which records the information in two separate tables.
What I'm trying to do is create a report which shows the information from both tables. Unfortunately, due to the clash in functions I don't know how this would be possible.
Does any one have any ideas?
Thank you for taking the time to read this.
Employer