how I can apply alphabetic grade

[khushee]

Hello friends.....
I am new here... and want your help...
Please tell me how I can apply alphabetic grade (A, B, C or F) in MS access

For example we have these marks of students

45
55
86
74
49

Then how I can apply grade to these values..

Hopping to see u soon.
Take care, and have a good time.

 

[FoFa]

Depends, you could use a nested IIF, or multiqueries or VBA. How did you plan on implementing this?

 

[Pat Hartman]

I would use a table that contains the letter grade with the matching numeric range:

tblGradeConversion
LetterGrade (primary key)
MinValue
MaxValue

So the data would look something like:

A, 95, 100
B, 85, 94.99
C, ....

Your query would look something like:

Select ..., Nz(c.LetterGrade, "Incomplete") as Grade
From YourTable as t Left Join tblGradeConversion as c On t.NumericGrade Between c.MinValue and c.MaxValue;

Please note that this is a non-equi join and you will not be able to create it in QBE view. You will need to switch to SQL view and you will no longer be able to use QBE view for this query.

 

[Laurentech]

Or how about:

LetterGrade = "F"
If Grade > 65 Then LetterGrade = "D"
If Grade > 70 Then LetterGrade = "C"
If Grade > 80 Then LetterGrade = "B"
If Grade > 90 Then LetterGrade = "A"

It's not fancy, but it will work.

Larry