weighted summary

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,
 
J

Jeff Boyce

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
 
M

Marshall Barton

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?


I think this will do that:

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

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