AnsweredAssumed Answered

entered value triggers 1 of 3 calculations

Question asked by tomo17 on Feb 18, 2011
Latest reply on Feb 21, 2011 by philmodjunk


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?