Totalling the number of recurring values

[AnnieP]

I am trying to total values which are the same, ie, initials of driver field
may have various answers, I am trying to find out how many times a driver
initials appear in the query and produce a list eg:

AA - 25 count
SD - 12 count etc etc

 

[KARL DEWEY]

SELECT Initials, Count([Initials]) AS Driver_Count
FROM YourTable
GROUP BY Initials;