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!

 

[Alansidman]

How are your grades kept. Numerical that needs to converted to Letter? If so, what is the criteria for each letter grade? ie. A= 92-100, B= 85-91, etc

 

[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

 

[Alansidman]

I don't know of any way to average letter grades. You will have to record grades using numbers and average them and then convert to letter grades.

Alan

 

[G37Sam]

Check out this thread:

http://www.access-programmers.co.uk/forums/showthread.php?t=231904&highlight=Letter+Grade

 

[atomiden]

ok thanks, it also worked with me.