8 Replies Latest reply on Jul 12, 2016 6:38 AM by buccillima

    Average three most recent data entries from a portal


      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!