Finding the Median of a group of values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a built a query to calculate the age of patients at their surgical procedure date. Is there any way it can be modified to display the median age of patients.
 
Total Visual Sourcebook has code to calculate the median.
The code will also interpolate if necessary.
http://www.fmsinc.com/products/sourcebook/index.html


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-


Kathleen said:
I have a built a query to calculate the age of patients at their surgical
Click to expand...
procedure date. Is there any way it can be modified to display the median
age of patients.
 
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

Multiple Median Calculation 4
Calculating median in a group by query 3
How to calculate the median in a GROUP BY query 13
group and median 1
Union Query 0
How do i calculate the median in access? 1
How do I calculate the median/other stats 7
Calculat Median for each data group? 3

Back
Top