Record Counting

[Neil Tompkins]

Hi,
 
I have a table of records all of which have a timestamp against them like 
2007-10-25 10:10:19, and category like red, blue etc and a unique key.
 
Using a SELECT statement is it possible to retrieve the count and number of 
records for each day e.g 2007-10-25 for all red, and all blue etc
 
Thanks.
Neil
_________________________________________________________________
Feel like a local wherever you go.
http://www.backofmyhand.com