Counting Records

[NormB]

I would like to be able to count how many time the catagory field contains a certain value. The following SELECT statement generates an error. Any suggestion?

SELECT catagory, rec_count=count(*) from tablename GROUP BY catagory

 

[THoey]

SELECT category, count(*) as Tot
FROM MyTable
Group By category Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.