I have a table named Employees and another table named EmpLeaves. Employees table holds all employee information while EmpLeaves is updated via a form and it has columns; EmpID, LeaveID and [Start Date].
I want to create a pie chart is a form which shows the number of employees present and absent for the current date. If there is a record for the employee in the EmpLeave table for the current date then they should be considered absent, otherwise if a record on the current date does not exist then present.
I need help with creating the table/query that will be the source for the pie chart. I can't seem to find a way to filter the employees who are present.