How do I count the total number of calls per each employee

[rahulroy08]

Hi,

I have been struggling with this report for quite sometime now.

I have a problem,which is counting the number of calls for each employee.

Here is how my data looks

EMP_
1.EMP_ID
2.EMP_GID
3.PID
4.EMP_NAME
5.EMP_TITLE
...
...


EMP_GOALS

1. EMP_ID
2. EMP_GID
3. EMP_PID
4. NAME_EMP
5. NAME_PROPERTY
6. NY_B_GOAL0
...
...
   INQ_G_0   (Inquiry Calls)
   PROS_G_0
   SIT_G_0


ACTIVITY

1. ACT_ID
2. ACT_GID
...
...
3. ACT_SYN_ID ( 14=INQ calls 15=PRO calls 39=Site Inspection)
4....
6....

I'm linking the EMP and EMP_GOALS By EMP_ID and the EMP_GOALS and ACTIVITY tables by EMP_PID and PID.

Now I want the count of number of Inquiry calls,Prospect calls, Site Inspections for each employee of a selected Organization.

How do i do that.


Any suggestions are appreciated.




Thanks,

Rahul.