weighted summary

  • Thread starter Thread starter iccsi
  • Start date Start date
I

iccsi

I would like to have my summary report weighted. I just wanted to know
are there any function available or I have write my own function.

I have report as following


Student ID, Exam, Result, Credits
1 Eng 80 3
1 Math 85 4
1 Phy 72 2



I would like have an average and sum of the stduent weighted by the
number of credits.


Are there functions available for the reports or I need write my own?

Your information is great appreciated,
 
You've asked a "how" question, but not explained how you are "weighting".
What formula do you use to derive the "weights"?

(Take a look at using a query to do the calculation that derives "weights".)

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
You've asked a "how" question, but not explained how you are "weighting".
What formula do you use to derive the "weights"?

(Take a look at using a query to do the calculation that derives "weights".)

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
iccsi said:
I would like to have my summary report weighted. I just wanted to know
are there any function available or I have write my own function.

I have report as following


Student ID, Exam, Result, Credits
1 Eng 80 3
1 Math 85 4
1 Phy 72 2



I would like have an average and sum of the stduent weighted by the
number of credits.


Are there functions available for the reports or I need write my own?
Click to expand...


I think this will do that:

the sym =Sum(Result * Credits)
the avg =Sum(Result * Credits) / Sum(Credits)
 
iccsi said:
I would like to have my summary report weighted. I just wanted to know
are there any function available or I have write my own function.

I have report as following


Student ID, Exam, Result, Credits
1 Eng 80 3
1 Math 85 4
1 Phy 72 2



I would like have an average and sum of the stduent weighted by the
number of credits.


Are there functions available for the reports or I need write my own?
Click to expand...


I think this will do that:

the sym =Sum(Result * Credits)
the avg =Sum(Result * Credits) / Sum(Credits)
 
Back
Top