Counting

[John Kinski]

I am trying to find a way to have a query count the
number of times a piticular office code is listed in a
column in my table. The office codes are 1 - 2 letters.
the name of the column in the table is District ID. What
I am trying to get out of the query is a list of the
offices and then the count as to how many times the
office is listed in the table.

Any thoughts?

thanks

 

[Duane Hookom]

Select [District ID], Count(*) as NumOf
FROM tblNoName
Group By [District ID];