entered value triggers 1 of 3 calculations
I am putting together a school marksbook from scratch with some great help and suggestions from forum members. I have hit a bit of a wall trying to get a grade calculated.
The database has a number of student records across different year groups eg 7, 8, 9, 10. For each year there is a slightly different but rather lengthy "IF" calculation to determine the grade. I have the calculations so that is not the problem, i just cant seem to work out how to get the database to read the relevant year grouping and then apply the appropriate calculation.
do i need to set up a calculation table that has two fields (eg: year , Calculation) or is there some other way?