Using Count function

[GaryJ]

Ok this is probably so simple, but I am relatively new to Access, so thats my excuse!!

I have a table that has student funding trigger data in it. one field is there course funding trigger, either "enrolment" "Completion" or ""Achievement"

All I want to do, is somewhere have a total of Completions and achievements.

I have attached a screenshot of my table so you can see what I mean - I have sprayed over certain personal data as these are real people !!

I want to then use the figures later to produce graphs, but one thing at a time!!

Any help would be appreciated

 

[pbaldy]

Try

SELECT Event, Count(Event) AS HowMany
FROM TableName
GROUP BY Event

 

[GaryJ]

Works perfectly - exactly what I wanted. Thank you so much!!!