Queries - Count items in a column

[turboace]

I have a large database one column contains data. For example colours - so each record is either green, red blue etc. The colours are not stored in a separate linked table as the main table is an extract from a different system.

I'm trying to produce a query which will count the number of records with each of the colours so...

Red 26
Blue 14
Green 6



How do I create one query to count each of the colours please?

Thanks

[lfpm062010]

Try

SELECT TABLENAME.COLORNAME, COUNT(TABLENAME.COLORNAME)
FROM TABLENAME
GROUP BY TABLENAME.COLORNAME;