View Single Post
  #12  
Old May 18th, 2010, 06:46 PM posted to microsoft.public.access.queries
SSi308
external usenet poster
 
Posts: 42
Default 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