AnsweredAssumed Answered

Sorting Question - Newbie

Question asked by Keith224 on Dec 18, 2013
Latest reply on Dec 20, 2013 by Keith224


Sorting Question - Newbie


     I have a sort question.  I have a table with a many records for each student.  There are 4 scores per year for each student.  I need to be able to sort those records in to the latest 16 records for each student by a field name [Year].  Then re-sort the previous sort into 10 records based on students [Score] from lowest to highest out of the previous sort of the 16 records.  Then from those 10 records have a calculation of the Average of those 10 scores.

     I am a relative newbie to Filemaker.  Formerly an Access user now converting to Filemaker.

     Thanks for any help!