SetanPutih
Registered User.
- Local time
- Today, 11:54
- Joined
- Jun 27, 2019
- Messages
- 27
Hi everyone,
I'm quite new to access so please be patient with me. I'm currently making an annual leave database for the company I work for. The fields I am currently concerned with are..
- ID
- Employee ID
- NumbOfDaysCarried
- NumbOfDaysRequested
- NumbOfDaysRemaining
The NumbOfDaysRemaining shows the value of [NumbOfDaysCarried]-[NumbOfDaysRequested]
What I'm trying to do is carry the NumOfDaysRemaining to NumbOfDaysCarried in a new record BUT only linked to a specific Employee ID. Therefore, the NumberofDaysCarried will gradually reduce according to the more NumberofDaysRequested.
In other words imagine the Employee ID is 10. After inputting holiday requests for numerous other clients, I wish to add a holiday request for Employee 10. What I want is the NumbofRemaining from the last holiday request from client 10 to carry over to the NumbOfDaysCarried to next request by Employee 10.
I really hope this makes sense. If anybody could help, I'd be really grateful.
I'm quite new to access so please be patient with me. I'm currently making an annual leave database for the company I work for. The fields I am currently concerned with are..
- ID
- Employee ID
- NumbOfDaysCarried
- NumbOfDaysRequested
- NumbOfDaysRemaining
The NumbOfDaysRemaining shows the value of [NumbOfDaysCarried]-[NumbOfDaysRequested]
What I'm trying to do is carry the NumOfDaysRemaining to NumbOfDaysCarried in a new record BUT only linked to a specific Employee ID. Therefore, the NumberofDaysCarried will gradually reduce according to the more NumberofDaysRequested.
In other words imagine the Employee ID is 10. After inputting holiday requests for numerous other clients, I wish to add a holiday request for Employee 10. What I want is the NumbofRemaining from the last holiday request from client 10 to carry over to the NumbOfDaysCarried to next request by Employee 10.
I really hope this makes sense. If anybody could help, I'd be really grateful.