weighted summary

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

 

[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

 

[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

 

[Marshall Barton]

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)

 

[Marshall Barton]

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)