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: