>You should be able to add GROUP BY and ORDER BY DayField into you SELECT statement.
>
>Stephen
>
It doesn't allow me to use DayField, but it does work if I use:
ORDER BY (cast(datepart(mm,time) as varchar)+'/'+datename(dd,time)+'/'+datename(yyyy,time))

After the GROUP BY

I thought I tried this before. I must have dropped a paren.

Thanks!

>
>>>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