How to get the final letter grade of my students letter grades in MS access

[erbrntos]

Hi guys! im having a problem in making the Expression or Formula on how to get the final letter grade of my records / data students letter grades. all my students grades are all in Letter form.



pls help!

thanks and God bless!

[June7]

Well, is the 'final' determined by a date value? You want to retrieve record where date equals the maximum date? Maybe this will help:
http://allenbrowne.com/subquery-01.html
Review the section Top n Records Per Group.

An alternative is to use DMax, something like:

SELECT * FROM table WHERE datefield=DMax("datefield", "table","StudentID=" & [StudentID])

[erbrntos]

I am directly recording the data through letter grades . and im using B=74 and below
d=75-79; AP= 80-84; P=85-89 ; A=90 and above...to give letter grades to my students.


pls help me to create an expression or fornula that will get the average letter grade of my list of letter grades in Query or form

[June7]

You want an average of letters? Need to assign each letter a number value then average the numbers and convert back to letter. Create a field in query with expression to convert letter grades.

GradeNumber: Switch([Grade]="A",5,[Grade]="P",4,[Grade]="AP",3,[Grade]="D",2,[Grade]="B",1)

Then you can use that constructed field in Avg aggregate calculation. Create a report and in textboxes use expressions to convert the average value back to letter.

tbxAvg
=Round(Avg([GradeNumber]),0)

tbxLetter
=Choose(tbxAvg,"A","P","AP","D","B")

[erbrntos]

it works!!!!
thanks a lot!