"sumOf" issue

Y

Yossi evenzur

Hi
how can change the "sumof" in the access chart into simple average? for
example, i have 3 students and I'm trying to calculate their success rate in
terms of pass/failed attempts meaning how many times they had to attempt to
pass the test. After calculating each one success rate i wanted to see the
over all success rate but the chart sums up each student success rate. so for
0.8,09 and 0.95 i get 2.65 instead of 0.883
 
J

John Spencer

Use Avg instead of Sum?

I am guessing that you are using an aggregate (totals) query to get the sum.
You should be able to replace Sum with Avg.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top