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!