I have data that I need to do a distinct count and I don't seem to be getting the right counts.
Sample of data:
The results that I expect are
PM - 2
BA - 1
But I am not getting that. I am getting
PM - 3
BA - 2
I am working in Access...Any thoughts?