AnsweredAssumed Answered

Average three most recent data entries from a portal

Question asked by buccillima on Jul 11, 2016
Latest reply on Jul 12, 2016 by buccillima

Hello, I'm very new to all this so any help would be greatly appreciated. I am a teacher building a database to do, among many things, keep track of my students' test scores. Sometimes, however, it's beneficial to average a student's 3 most recent test scores. I have created a student table related to an tests/scores table. I have created a student table layout with a portal that shows test scores. Is there any way that I can average the 3 most recent test scores that appear in the test scores portal? I hope that is enough information to go on. Thanks for any help!