See below.
> What does the > 1800 do the equation?
It only includes users calling a total of 30 mins or more. You
can drop that line altogether.
Select UserName, Mon=DatePart(Month, CallDate),
Hrs=(Sum(AcctSessionTime)/3600)
From Calls
Group By UserName, DatePart(Month, CallDate)
Order By UserName, DatePart(Month, CallDate)
Compute Avg((Sum(AcctSessionTime)/3600)) by UserName
-- Dale E. Reed Jr. (daler@iea.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com