How to get statistics

[Girish]

Hi,
I have the requirement to get the count of rows for each
Type.There are 20 of such type.The data is stored in MS
Access.How to go about

Anyhelp in this regard is highly appreciated

subbu

 

[John Viescas]

SELECT Type, Count(Type)
FROM MyTable
GROUP BY Type

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR?pg=personal&fr_id=1090&px=1434411

 

[girish]

Thanks John for the query

regds
subbu

-----Original Message-----
SELECT Type, Count(Type)
FROM MyTable
GROUP BY Type

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR? pg=personal&fr_id=1090&px=1434411



.