Hi Rebecca,
Assuming the table is Personnel and the last name field is cLastName:
SELECT ;
LEFT( cLastName, 1 ) AS cLetter, ;
COUNT( * ) AS nCount ;
FROM Personnel ;
GROUP BY 1 ;
ORDER BY 1
HTH,
>Is anyone out there a SQL expert? I'm trying to count all the people in my personnel table and group them by first letter of last name. I want my result set to look like this:
> A 203
> B 309
> C 594
>
> etc.
>
>I can do this with multiple count statements, but am wondering if it is possible with a single SQL select statement.
>
>Thanks in advance,
>Rebecca Burlingame
Evan Pauley, MCP
Positronic Technology Systems LLC
Knoxville, TN
If a vegetarian eats vegetables, what does a humanitarian eat?