AnsweredAssumed Answered

finding two (or more) lowest values in a field

Question asked by StevenNardi on Jan 15, 2015
Latest reply on Jan 15, 2015 by StevenNardi


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).