You should be able to add GROUP BY and ORDER BY DayField into you SELECT statement.
Stephen
>>SELECT (cast(datepart(mm,time) as varchar)+'/'+datename(dd,time)+'/'+datename(yyyy,time)) AS DayField,
>>COUNT(CondoDir) AS Hits FROM wwRequestLog
>>WHERE UPPER(CondoDir) LIKE 'FRANKLIN'
>>AND DATEDIFF(day, time, getdate()) < 14
>>GROUP BY (cast(datepart(mm,time) as varchar)+'/'+datename(dd,time)+'/'+datename(yyyy,time))
>>
>>
>>TIA
Stephen Lee
--------------------------------
Too much to code
Too little time
--------------------------------