A Query that counts the # of Records according to the first letter?

[djclntn]

Can anyone kindly tell me how to create a query that will tell me how many ‘Cities (Records) I have in my Table with the first letter starting with, “A,” “B,” “C,” etc.?



Query will look something like:
A 10
B 15
C 20

Thanks!

[pbaldy]

SELECT Left(FieldName, 1) AS FirstLetter, Count(*) AS HowMany
FROM TableName
GROUP BY Left(FieldName, 1)

[djclntn]

Table Name Is: 'Territory Codes'
Field Name is "trrtyCd"

I tried this in SQL, doesn.'t work:

SELECT Left(TrrtyCd, 1) AS FirstLetter, Count(*) AS HowMany FROM Territory Codes GROUP BY Left(TrrtyCd, 1)

[pbaldy]

Because of the inadvisable space, you need to bracket the table name.

[djclntn]

Thanks Paul!

[pbaldy]

No problemo!