Hi,
I want to check if on particular date a particular employee was on leave or not.
Table 1 is the list of employee with absences during the month and Table 2 is the leave data for that month. I want to check whether employee 1001 marked absent on "x" date has an approved leave in Table 2 and similarly for other employees in Table 1.
Sample file is attached for reference.
Thanks
I want to check if on particular date a particular employee was on leave or not.
Table 1 is the list of employee with absences during the month and Table 2 is the leave data for that month. I want to check whether employee 1001 marked absent on "x" date has an approved leave in Table 2 and similarly for other employees in Table 1.
Sample file is attached for reference.
Thanks