I am working on a database for scoring an event but have hit a glass ceiling. Unsure what would work best for an expression and if I should use a query or module. I need it to take each entry’s scores and delete the lowest and highest scores and then display an average. If there is more than one score with the same low number it will only delete one of them. What should I do? I have tried several expressions but cannot seem to get it working.
