It can be done. You need to be more specific it what you want.

Average number of calls by type.

Do you want
== average per day over a period of time by department
== average per day over a period of time by employee
== average for the entire period of time by department
== average for the entire period of time by employee
== something else?


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

SSi308 wrote:
John,

Many thanks for the help you have given. I was able to create and
successfully run the first query dealing with total calls and percents.

I now need to calculate the average calls each person made and received for
a particular time period.

My first Query, CallsPerDay, includes for each employee:
TotalCalls
3+Calls
OutCalls
InCalls
PtCallsOut (percentage of calls outgoing)
PtCallsIn (percentage of calls incoming)
PtCalls3+ (percentage of calls over 3 minutes)
PtCallsOut3+ (percentage of outgoing calls over 3 minutes)
PtCallsIn3+ (percentage of incoming calls over 3 mintues0

Now based on the number of calls per day per employee I need to calculate
the average number of: In; Out, and 3+ calls.

Can you help me out?

Lori