Ok. Now I really feel stupid. I guess thats what I get for not actually
trying it. You just need to remove the ", count(Calldate) from the end of
the Group by and Order By lines and it will work (and yes, I tested it this
time).
> >Select DatePart(Year, CallDate), DatePart(Month, CallDate), Count(CallDate)
> >From Calls
> >Group By DatePart(Year, CallDate), DatePart(Month, CallDate), Count(CallDate)
> >Order By DatePart(Year, CallDate), DatePart(Month, CallDate), Count(CallDate)
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com