Need Help with Totals Query
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
|