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.

5 replies

by john_wills

It seems to me that the expression you need is SELECT (sum(x)-max(x)-min(x))/(count(x)-2) AS answer
FROM thetable.
This seems too easy, so perhaps I have not understood your problem, or perhaps my SQL is not so good as I think.

by sap

So you are working on event management system. According to me for the required task you must go for module. If you are thinking for get solved send me that form and I will get it finished.

This discussion is closed to new replies.