Generate Sum from a work center and order #

[KrenzyRyan]

I have a basic problem, hopefully you guys have a basic solution



I have a very large data set and here is a very small snapshot. Basically, I want Access to Find the average hours worked per work center per order/chrg#.

As you can see, there are various "hours worked" per load center per order. Is there a way to have access find the order number, sum all the "hours worked" for each individual load center (within that order) together, and produce a unique sum of hours worked per order number, per work center?



Here is some data and an example of what I want to do:

[ConneXionLost]

Assuming you have all your data in one table (tblOrders), then just run this query:

SELECT tblOrders.Order, tblOrders.WorkCentre, Sum(tblOrders.HoursWorked) AS SumOfHoursWorked
FROM tblOrders
GROUP BY tblOrders.Order, tblOrders.WorkCentre;

[KrenzyRyan]

Thank you, this worked great!