finding two (or more) lowest values in a field
This is for a database tracking student grades. I have a field where I enter the points scored on individual quizzes, and then a layout that totals the number of possible points compared with the total points scored by each student.
I would like to make it possible to forgive each student's lowest scores. I know I can use the "min(field)" function to find the lowest value in the field holding the marks, but how do I identify the lowest two (or more) values? I need a way to find the bottom two (or three or four--ideally I could decide later how many to drop).