B Bob Barrows [MVP] Mar 10, 2006 #2 Kathie said: Can you calculate a weighted average in access? Click to expand... Yes. It's not the easiest thing to do, but it is possible. For example, given a table with two columns, Value and WF (weighting factor), you would do this: select sum([Value]*[WF])/(select sum([WF]) from table) as WeightedAverage from table
Kathie said: Can you calculate a weighted average in access? Click to expand... Yes. It's not the easiest thing to do, but it is possible. For example, given a table with two columns, Value and WF (weighting factor), you would do this: select sum([Value]*[WF])/(select sum([WF]) from table) as WeightedAverage from table
