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
- Record Counting Neil Tompkins
- Re: Record Counting Ravi Kumar.
- Re: Record Counting Peter Brawley
- Re: Record Counting Ravi Kumar.
- Re: Record Counting ranjeet walunj