I have been trying to convert percentage grade to letter grades without success. I am trying to do this in a query. The grades equaivalents are
0-44 = F
45-55 = D
56-70 = C
71- 89 = B
90-100 = A
Kangaroo
I have been trying to convert percentage grade to letter grades without success. I am trying to do this in a query. The grades equaivalents are
0-44 = F
45-55 = D
56-70 = C
71- 89 = B
90-100 = A
Kangaroo
You could make a table that would have the grades. You would have 3 fields. One field for the beginning range, one for the ending and one for the letter grade e.g.
Low End High End Grade
0 44 F
45 55 D
You could then either write a function or perform something like DLookup in your query, using that table where you would get the value of each row,
how Do I write the function to convert the Percentage grade to Letter grades? I'm new to databases
Kangaroo