I have 2 tables Students and Results.
In Results Table i have 2 feilds, Supplementary and marks. In Students table i have a feild called final.
Now i need a calculation for the final feild, like
Supplementary = "";
For the above sum results i need if Sum(Results::marks) < 40;
Sum(Results::marks) > 40;
Sum(Results::marks) > 80;
So basically i need to satisfy more than one condition in case statement. is it possible.
Thanks in advance.