Assigning an Alpha Grade to Numeric Grade

D

Dave White

I have created a report that calculates a Number Grade for each of my
students.

If a numeric grade falls between a range of numbers I would Like the
report to enter the corresponding alpha grade.

Between 97 and 100 = A+
Between 93 an 90 = A
etc.

The solution eludes me for reports (and queries).

Any suggestiions would be appreciated.

Thanks,
Dave
 
A

Allen Browne

Create a table with fields like this:
MinScore Number
Grade Text

You can then enter records:
97 A+
93 A
and so on.

You can then create a query that matches the letter to the score. Tom
Ellison details the most efficient solution (to execute, though it takes a
bit to set up) here:
Lookup in a range of values in a query
at:
http://allenbrowne.com/ser-58.html
 
F

fredg

I have created a report that calculates a Number Grade for each of my
students.

If a numeric grade falls between a range of numbers I would Like the
report to enter the corresponding alpha grade.

Between 97 and 100 = A+
Between 93 an 90 = A
etc.

The solution eludes me for reports (and queries).

Any suggestiions would be appreciated.

Thanks,
Dave

Regarding
Between 97 and 100 = A+
Between 93 an 90 = A
Click to expand...
What do you do if a grade value is 94 or 95 or 96, etc.

Add a new table to your database.

GradeID AutoNumber NoDuplicates
GradeNum Number Integer
Grade Text
Name the table "tblGrades"

Enter the grade number which represents to lower value of the range
and it's text value, entered in Descending GradeNum order., i.e.
GradeNum Grade
97 A+
95 A
93 A-
90 B+
85 B
83 B-
80 C+
etc.....

So that a value of 95 or 96 represents, for example, an A.
(Change the above grade numbers to reflect your wanted Grade values
and numbering.)

Then in your report, add an unbound text control where you wish to
show the Grade. Set it's control source to:

=DLookUp("[Grade]","tblGrades","[GradeNum] <= " & [NumberGrade])
The report will display the letter value for the range in which the
[numbergrade] sits.
 
D

Dave White

Thank you both for your inciteful input.

I now have some meaningful info to analyze.

Good Luck,
Dave
 
Top