How to calculate # of first letters of names in a field

[djclntn]

I’m sorry, but I don’t know how to write out the query I’m trying to create so I’ll create an example:

Field: Drivers Names
I want to know how to create a query that will calculate the # of “drivers names” which starts with, “A”, “B”, “C” etc.“
I want my query to be:

Drivers’ names first letter # of first letters
A 10
B 19
C 15


Can anyone know & tell me how I can create such a query
Thanks

[pbaldy]

Try

SELECT Left(DriverNameField, 1) As FirstLetter, Count(*) As HowMany
FROM TableName
GROUP BY Left(DriverNameField, 1)
ORDER BY Left(DriverNameField, 1)

[djclntn]

I'm sorry, mightt you provide me with some more precise step-by-step details as to creating such a query?
　
　
Thanks.

[RuralGuy]

Open a new query in design mode and switch to SQL View. Copy and Paste what Paul provided and replace DriverNameField with the name of your field. Then switch to Datasheet View and see what you get.

[djclntn]

Heres' what I tried,

SELECT Left(Drivers, 1) As FirstLetter, Count(*) As HowMany
FROM Series Results
GROUP BY Left(Drivers, 1)
ORDER BY Left(Drivers, 1)

No luck

[RuralGuy]

What do you get?

[djclntn]

Cnnot find 'Series' in Tables or Queries

[djclntn]

I figured it out! Thanks a lot!!!

[RuralGuy]

We're glad we could help.

[djclntn]

Hey,

I don't mean to overkill here, but you REALLY help me out! Thanks Again!

[RuralGuy]

Both Paul and I appreciate your sentiments. That's why we hang out here. You are very welcome.