Summing groups of figures from the same field.

[passinthru]

I have a table which has several fields as follows:

Project Name | Employee Name | Title | Hours


For each Project Name, I need to get the total hours by title. IOW, if on Project X there were 4 Junior Glass Polishers, 4 Senior Glass Polishers, and 1 Super Senior Spot Remover, I'd want three totals - the total number of hours expended by each of the three job titles that were assigned to that project. Something like:


Junior Glass Polishers: 82 hours
Senior Glass Polishers: 108 hours
Super Senior Really Tiny Spot Remover 14 hours


And I need those numbers for each project. Any given project might have any combination of the various Titles working on it.


I have created some basic queries in the past, but I have no clue how to structure this one.

Anyone feeling merciful today?

 

[Dugantrain]

This is pretty simple, you just need to use an Aggregate Query. In a query, pull in the three fields that you're wanting to see. Click the Sigma sign in your toolbar (the one that looks kind of like a Capital 'E'). You will now have a new 'Total' Row. By Default, all three fields will say 'Group By'. Leave the first two fields as they are and change the last one to 'Sum'. This will give you your desired results.

 

[passinthru]

Whoa. That was too eazy. There MUST be a catch!





Thank you very much!