Access problem

[asdd dkek]

I'm playing around with Access.

I am buildiing a program to calculate grades for my students. I can get it
to average the final grade, but I can't get it to take the numerical value
and convert it to an alphabetical grade. Any ideas would be helpful.

I have, for example, 6 grades. One average is 69. I want that to be a C in
a query. Ideas??????

Kirk

 

[Allen Browne]

Create a table that contains the minimum score and the matching grade
letter.

You can then get the grade by looking up that table.

Tom Ellison explains the finer points here:
Lookup in a range of values in a query
at:
http://allenbrowne.com/ser-58.html