Expr1: (SELECT DISTINCT T1.[Rating Choice]
FROM [Bear Gun Results] AS T1)
I'm trying to count each unique category within one field.
EX:
Good
Good
Good
Excellent
Poor
Poor
The final output should be:
Good = 3
Excellent = 1
Poor = 2