How to get the Count and Total

[dupati1]

Hi All,

I need suggestions on this particular issue. I have a requisition table in which i store the Empolyee Name who solved the requisition and also time spent by the employee to solve it.

Now my problem is there are around 8 department employees who look into the requisitions submitted by all the employees of the organization and provide solutions.

I would like to keep a record of these activities( i mean like maintaining statistics). How can i get the following information:

1. How many requisitions were solved by any particular employee
2. Total time spent by this employee to solve these requisitions
3. Total number of requisitions submitted by all employees of the organization
4. Total time spent by the department staff to solve all these requisitions

Thanks

VJ

[TheNige]

I'm assuming you are using SQL?

Just write a query that gets the count for the stuff you want to know. You may also need to do some Group By queries.

I suggest looking at some SQL websites for help. You can do a Google search for "SQL Tutorial" to find these.

[aspdaddy]

For those queries you can use basic SQL

select count(*) FROM tbl_reqs where emp_id = [?]
select sum(time) from tbl_reqs where emp_id= [?]
select count(*) from tbl_reqs
select sum(time) from tbl_reqs

For reports, add employeee_id to the SELECT and GROUP BY it.