Can I count multiple items in one field?

[webmagic]

Hello,
I think maybe there is a flaw in my design, so any help or suggestions would be appreciated.

I have a table which has the fields name, productivity, grade. The grade is based on a formula and is A,B,C, D. These grades are given the time the query is ran. Is there a way I can Add how many A's, B's etc. a person has? Should I have done this another way?

Thank in advance for any help.

 

[redneckgeek]

I'm including a subquery for this example, but you could use a saved query instead:

SELECT NAME, GRADE, COUNT(GRADE) AS CNT
FROM (
    SELECT NAME, [INSERT YOUR GRADE CALCULATION HERE] AS GRADE
    FROM YOURTABLE) RS
GROUP BY NAME, GRADE

 

[webmagic]

I get an error message stating I have to use the Exists reserved word. When I search i get nothing on how to fix this. Any ideas?

Thank you for your help. I am working in Access 2000 and have just enough experience in Access 2000 to get me in trouble.

Thank you

 

[redneckgeek]

Post the SQL of the query you are actually using.

 

[webmagic]

I got it working -thank you!