How do I calculate median values using access?
SELECT MAX([ThisColumn]) - MIN([ThisColumn]) * .5 AS ThisMedian
FROM ThisTable
I'm a bit weak on medians, but This might be pretty close to what you want
--
Peace & happy computing,
Mike Labosh, MCSD
"Mr. McKittrick, after very careful consideration, I have
come to the conclusion that this new system SUCKS!"
