Calculating monthly tasks

[syedadnan]

Rgards,

I have a query, i need to get dsum of total task given to an employee.
I have grouped task_description and select count and it is now showing each employee as 1 which is correct.. i ma looking to get dsum based on this task count but with a criteria that i want to see these tasks sum month a have a month field which i get from assigned date the month field is showing like this december-2013.

based on this i want to calculate dsum as first to see task count which i mentioned earlier, then employee id which is in query as ID and then month.. this sum will help me calculating monthly tasks given to each employee.

 

[plog]

Can you post sample data from the data source this data is in? Also post what data results you expect based on the sample data. Use this format for posting data:

TableNameHere
Field1Name, Field2Name, Field3Name
David, 16, 2/7/2008
Larry, 41, 12/2/2004

 

[Geotch]

I've uploaded a sample, think it's what you are asking for. I always create a common field to easily link multiple queries together. In this case I created a field called "site" and created three queries. One with the averages by year and month by task for each employee, one for averages by each task and the final, joined them together.

Hopefully you can follow the queries and understand what I did.

 

[plog]

I don't care what you've done, in fact that's a hinderance. I want to know your starting data and what data you expect in the end based on that sample data.

 

[jdraw]

I agree with plog--don't tell how you've done something that doesn't satisfy your requirement.
Start by telling us WHAT you are trying to achieve. Use your own data to show the start and tell/show us WHAT you want as a result.

 

[syedadnan]

I agree with plog--don't tell how you've done something that doesn't satisfy your requirement.
Start by telling us WHAT you are trying to achieve. Use your own data to show the start and tell/show us WHAT you want as a result.

Thanks for the reply.. though ihave done it through text box in report and collected information. It was difficulit to explain the requirement.