title: How to show all employees absent dates only in MS Access 2010 query?
body: <p>I want to have a query which shows me records of only those employees that were absent on various dates.</p>
  
  <p>I have two queries in MS Access 2010. One is <strong>qAllDatesAllEmp</strong> which has all monthly dates for all employees. Second is <strong>qDailyWorkEmp</strong> which shows date-wise the working of employees. Now, say Emp1 had only one missing date of <code>5-Jan-2019</code>; emp2 had <code>15-Jan-2019</code> missing and so on, the result should show me only these missing dates with employee names. What i have tried so far is that I have joined the date field from <strong>qAllDatesAllEmp</strong> to the date field in <strong>qDailyWorkEmp</strong> with join arrow pointing from <strong>qAllDatesAllEmp</strong> to <strong>qDailyWorkEmp</strong>. I also added the date field from <strong>qDailyWorkEmp</strong> to the query grid below but removed the check mark. When I run this query, it gives blank result. I would really welcome the experts' help on how to get the desired output below.</p>
  
  <p>My Sample Data:</p>
  
  <pre><code>Query1: qAllDatesAllEmp contains {WorkDate; empID; empName; CityBased}
  Query2: qDailyWorkEmp   contains {DailyDate; empID; empName; CityBased}
  </code></pre>
  
  <p>The SQL for this is as follows:</p>
  
  <pre><code>SELECT qDailyWorkEmp.empID, qDailyWorkEmp.empName, qDailyWorkEmp.CityBased
  FROM qAllDatesAllEmp LEFT JOIN
       qDailyWorkEmp
       ON qAllDatesAllEmp.WorkDate = qDailyWorkEmp.DailyDate
  WHERE (((qDailyWorkEmp.DailyDate) Is Null));
  </code></pre>
  
  <p>My desired output:   </p>
  
  <pre><code>    empID; EmpName; MissingDate
  
      001;    ABC;       5-Jan-2019
  
      007;    LMN;      15-Jan-2019 
  
  ...and so on
  </code></pre>