Totalling the number of recurring values

  • Thread starter Thread starter AnnieP
  • Start date Start date
A

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
 
SELECT Initials, Count([Initials]) AS Driver_Count
FROM YourTable
GROUP BY Initials;
 
Back
Top