title: MS Access query with no duplicates
body: <p>I'm working on building a query where it doesn't allow for duplicates. I've built a task/time manager and in the table for it I created a column called "Active". It's a true/false switch that signifies if an employee is busy or free. I'm now building a query where I want it to show if "active" switch is true then it shows as "Busy" otherwise if it's false they are "Free". I can get this to work but it shows duplicates. In the table I do have it indexed to not show duplicates but I'm still getting them. </p>
  
  <p>Here is the SQL View:</p>
  
  <pre><code> `SELECT Employees.Employee
   , IIf([Active]=True,"Unavailable","Free") AS Avail
   FROM tblTasks INNER JOIN Employees ON tblTasks.[User ID] = Employees.UserID;`
  </code></pre>
  
  <p>This is the current setup:
  <a href="https://i.stack.imgur.com/lUoj5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lUoj5.png" alt="CurrentSetup"></a></p>
  
  <p>And this is the current output:</p>
  
  <p><a href="https://i.stack.imgur.com/XN5hB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XN5hB.png" alt="Output"></a></p>
  
  <p>Ultimately the goal is to get it so that if any employee has a "True" flag on the "Active" field then they appear once as "Unavailable" but if they have all "False" tags on the Active field they appear once as "Available". </p>
  
  <p>Any help would be greatly appreciated.</p>