Hi Neil, Try this:
SELECT LEFT(DATE_FIELD_NAME, 10), COLOR_FIELD_NAME, COUNT(T.*) AS CNT FROM TABLE_NAME GROUP BY LEFT(DATE_FIELD_NAME, 10), COLOR_FIELD_NAME. Post the table structure if this does not help. Regards, Ravi On 10/27/07, Neil Tompkins <[EMAIL PROTECTED]> wrote: > > 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