Easy query for you Access Studs

[Jason Stephens]

I have a simple table that has only 2 colums, a name and a type. IE:
Name Type
------------------
Jason 1
Paul 3
John 2
Sally 3
Ron 2


What I need is a query that will give me a count for each type. The example
output for the above data would be:

Type Count
------------------
1 1
2 2
3 2


Etc. What is the correct syntax to get these results? Responses as SQL
statements would be fine. Much love and appreciation!

--Jason

 

[John Spencer]

SELECT [Type], Count([Type] as CountType
FROM [YourTable]
GROUP BY [Type]