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.

 

[reclusivemonkey]

What numeric score constitutes an

1. A
2. B
3. C
4. F

?

 

[khushee]

What numeric score constitutes an

1. A
2. B
3. C
4. F

?

if marks are

> or = 80 then A
> or = 70 then B
> or = 60 then C
> or = 50 then D
< 50 then F

 

[reclusivemonkey]

Hi khushee,

Please keep the discussion in the thread, not in PM's; that way everyone can benefit. Thanks.

This nested IIF should work;

Grade: IIf([Score]>=80,"A",IIf([Score]>=70,"B",IIf([Score]>=60,"C",IIf([Score]>=50,"D","F"))))

 

[khushee]

please tell me
is [Score] a column name??

and can i use it as i use grade formula in excel?

 

[reclusivemonkey]

[Score] is the field your Scores are in (i.e. 45, 55, 86, 74, 49). Change [Score] to whateve you call this field in Access.