Hi!!
I have a query that i would like to make it as custom as possible.
It grades students according to marks achieved, however grading systems may vary in different institutions or so.
I know there may be two approaches in tackling this like using a Table or parameter queries but i seem to end up in the same mess either way.
i use the following function to show grade:
Code:
Grade: IIf([Marks]>=80,"A",IIf([Marks]>=75,"A-",IIf([Marks]>=70,"B+",IIf([Marks]>=65,"B",IIf([Marks]>=60,"B-",IIf([Marks]>=55,"C+",IIf([Marks]>=50,"C",IIf([Marks]>=45,"C-",IIf([Marks]>=40,"D+",IIf([Marks]>=35,"D",IIf([Marks]>=30,"D-",IIf([Marks]<30,"E"))))))))))))
What i want to achieve is to alter the marks and grade as per user requirement in a form.
can this be possible if so how?