auto updating field

[etsmarines]

If I have a field that shows a students current grade and want to have another field show thier expected graduating year how do I set this field up and what should my calculation look like. For example if the student is is PK and it is 2010 how do I make a field show that his graduation year will be in 2023. Or if I change his grade to 5th grade for example I want the field to auto update to show that he will graduate in 7 years making his graduation year 2017.

Please Help!

Thanks Again,

Erik

[bcooney]

Comment answered this question for you here.

[etsmarines]

I dont know how to write the calculation.

Thanks.

Erik

[bcooney]

You'll need each of the fields that he suggested in the calc.

YearEnrolled - GradeEnrolled + YearsOfProgram + GradesRepeated - GradesSkipped + 1

then, define the field, GradYear as a calc equal to the above.