conditional expression

[banner]

I need help on building an expression, I have one table that just holds students grades, A,B,C,D,E AND another table holds students final grade percentage and Grade i had built the other grade table so it would be easier to have a list of valuse to select, but i want it more automatic,

i would like to build an expression that if a student gets anywhere between 80%-100% the Grade of A , 70%-79% the Grade B, etc is automtically put in on the Final Grade Table.

Can some one please help , i am pulling out what little hair i have left,

A.S.A.P

 

[banner]

great start, still need soem help

Can you tell what is a public function?

Create a public function to return the letter grade:

and can you please tellme step by step where would i putthis expression in what table?