Hi Everyone,
I want to create a query that shows if an employee is absent or not. I have a date table that has everyday in it for tor the next 3 years. There is another table that has employee information (Name, employee ID, etc), then there is another table that hosts employee Logins (employee ID, time in, time out, date, etc).
I need to create a query that checks for every employee in the employeelist for everyday in the datetable, to see if they logged in or not (in the employeelogin table). If that employee did not login that day, there would be a field that would have a status of "Absent".
Ideas? It sounds simple, but i cant figure it out.