title: Creating a query to count non duplicated patient interactions per day
body: <p>I am fairly new to Microsoft Access but I recently created a database to better organize our department data. In my database I have a table that our staff can log their interactions with patients. A staff member can have multiple interactions with one patient in a single day but when we report our stats to the boss they only care about "how many patients were seen per staff member per day". And I cannot figure out how to get that done using my query.</p>
  
  <p>To further explain what I need here is an example:</p>
  
  <p>On Monday, employee1 sees patient-A twice, patient-B once and patient-C once. Employee2 sees patient-B once and patient-D once.</p>
  
  <p>On Tuesday employee1 sees patient-A once and employee2 sees patient-C three times.</p>
  
  <p>And the Query should show: employee1 - 4 interactions and employee2 - 3 interactions.</p>
  
  <p>Hopefully I was able to paint a good enough picture. </p>
  
  <p>Thank you,
  M</p>