Query not showing unique values when using <>

[acarterczyz]

Hey all!

I'm trying to make a query off another query where it will give me a list of unique managers, and the number of sales reps underneath them. I'm also trying to set it up to omit two sales reps who appear under everyone (hold placements).

Here is what I have:

SELECT VP_RVP_ListQuery.VP, Count(VP_RVP_ListQuery.[Rep Number]) AS Active
FROM VP_RVP_ListQuery
GROUP BY VP_RVP_ListQuery.VP, VP_RVP_ListQuery.[Rep Number]
HAVING (((VP_RVP_ListQuery.[Rep Number])<>"1234OT" And (VP_RVP_ListQuery.[Rep Number])<>"1234567"));

The issue I'm having is, it completely ignores the fact I want unique values and just gives a count of each line listed individually. How can I just get unique list of managers, total count of sales reps underneath them, and omit the two reps?

Thanks in advance!

Edit: here is a screen shot of what I get...

 

[pbaldy]

You have VP_RVP_ListQuery.[Rep Number] in the GROUP BY clause; you don't want it there.

 

[acarterczyz]

Fabulous. Thank you!!

 

[pbaldy]

Happy to help!