title: Count unique values in Access query
body: <p>I'm pretty much an Access n00b, but I've built a basic database for a friend's school to keep track of students seeing the counselling team. They're all pretty happy with it, but they've asked if it's possible to quickly see how many students each counselor is seeing.
  I have tables set up for staff, students, and case notes, and I thought it would be easy to create a query that does this, but I cant get it to work; it keeps returning the number of case notes per staff member, rather than the students:
  <a href="http://i.stack.imgur.com/afXLQ.png" rel="nofollow">Query right now. Staff #7 has seen one student twice.</a></p>
  
  <p>What I'd like it to do is tell me how many students each counselor is seeing, based on the case notes they've entered.</p>
  
  <p>I'm really hoping for a solution I can implement in design view, rather than SQL.</p>
  
  <p>You can DL the database if you want to look at it:<a href="https://drive.google.com/file/d/0B0RvbnEcKEagZldJMDZkZmkybkk/view?usp=sharing" rel="nofollow">https://drive.google.com/file/d/0B0RvbnEcKEagZldJMDZkZmkybkk/view?usp=sharing</a></p>
  
  <p>(It's all dummy data)</p>
  
  <p>Thanks in advance for any guidance you can offer me.</p>