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.

 

[Pat Hartman]

khushee,
You now have at least two threads on this topic with different answers. Please in the future do not post multiple threads with the same question. It simply wastes the time of the people you are asking to help you.