I've been looking for an easy way of finding a median value in a list of numbers. All the methods of doing it look like rather nasty code. However, I've come up with a more elegant solution that looks better than most of the methods out there, at least for Access SQL.

Something like the code below has worked well for me. And the nice thing is that it's all done in SQL.

SELECT LAST(Number)
FROM (SELECT TOP 50 PERCENT Number
FROM tblList
WHERE Number<>''
ORDER BY Number);