Letter Grades in Classroom Management Database

[Guest]

I am a novice with Access, and I have been in the process of adapting the
Classroom Management Database template to fit my unique needs, and I am
almost there. Currently, it seems that the letter grade field is entered
manually. I was wondering if it is possible to have the letter grade entered
automatically based on the percentage grade, which is already automatically
calculated. That is, if the student has a % grade of 86%, can I program it
to automatically put a B in the Letter Grade field, and so on?

 

[Douglas J. Steele]

Take a look at my December, 2004 "Access Answers" column in Pinnacle
Publication's "Smart Access".

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html