smtazulislam
Member
- Local time
- Today, 04:25
- Joined
- Mar 27, 2020
- Messages
- 806
Thanks for any help.
In the attached dB, I want to show .............
Table Employee is "Status = Active"
Table Transfer is "Status = Transfer"
Table Vacation is "Status = Back Vacation"
How to work it :
First checking Employee Table with Status is "Active" Then Transfer Table with tStatus is "Null Or Transfer" or "Current". ("Current" meaning he is work any company. And "Transfer" meaning he don't have work).
then need to confirm that he is return from Vacation or Not. (If he return from Vacation then vStatus will be "Back Vacation") .
Criteria Like : Status = "Active" And tStatus = "Null or Transfer" (Note: Latest Record) And vStatus ="Back Vacation" (Note: Latest Record)
Show how many employee Not Transfer yet : .................
In the attached dB, I want to show .............
Table Employee is "Status = Active"
Table Transfer is "Status = Transfer"
Table Vacation is "Status = Back Vacation"
How to work it :
First checking Employee Table with Status is "Active" Then Transfer Table with tStatus is "Null Or Transfer" or "Current". ("Current" meaning he is work any company. And "Transfer" meaning he don't have work).
then need to confirm that he is return from Vacation or Not. (If he return from Vacation then vStatus will be "Back Vacation") .
Criteria Like : Status = "Active" And tStatus = "Null or Transfer" (Note: Latest Record) And vStatus ="Back Vacation" (Note: Latest Record)
Show how many employee Not Transfer yet : .................