need help starting

  • Thread starter Thread starter zaps
  • Start date Start date
Z

zaps

Hi there,

I have 2 tables in my database, imported from excel. I work for a call
centre. One table has a list of all the calls we took in a month.
Information as Customer Name, Date they called, service provided, and the
name of the phone operator. The second table has a list of the complaints
for the month. Information like what the complaint was about, date, the
phone operator's name who the complaint is against etc.

I would like to make a report, showing the percentage of complaints a call
operator gets. How many complaints they get divided by the total number of
calls they took a month.

Any ideas how i should start?
Any help would be great!

Thanks,
Michelle
 
What I think you could do is for the first table create a
totals query, this should group by operator and simply
count the number of calls. Than create a similar totals
query for the complaints table also grouped by operator
and count. Now you can devide one count by the other to
come up with the information you asked for.
Hope this helps.
Fons
 
Back
Top