median values using access

  • Thread starter Thread starter Guest
  • Start date Start date
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!"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Median 4
Calculation for Median 3
calculate median in Access 1
Having a problem with calculating medians in access 1
median 31
Finding Median 1
How do I build an expression to get the median? 4
Calculating the Median for specified groups 1

Back
Top