Adding Averages

[yt100]

SOLVED: Adding Averages

SOLVED:Hows it goin

Ive got a report that contains three separate entries under the field name Average. I've made little peice of code that calculates a grade for these three averages

=IIf([Average]>79,"A",(IIf([Average]>64,"B",(IIf([Average]>49,"C",(IIf([Average]>39,"D",(IIf([Average]>0,"E"," ")))))))))

This seems to work for the three individual averages. However what i need to do is add the three averages up and calculate an overall grade. So far all ive managed to do is run into dead ends like

=[Average]+[Average]+[Average]

which just multiplies the 1st average by three

if you need further clarification just tell me,
thanks in advance

 

[Rabbie]

Do the three different Averages calculatred in your report or are they in your data source for the report.

You will need to identify where the figures are that you want to sum and then write your formula.

 

[yt100]

solved it

Thanks mate but i solved it, forgot to post that. It looks a bit messy in design view but thats ok i guess.

good on ya