Discussion Locked
MS Access that Deletes and Averages
0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.