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?

 

[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