Finding the Median of a group of values

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.
 
M

[MVP] S. Clark

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.
 

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
Union Query 0
How to calculate the median in a GROUP BY query 13
How do I calculate the median/other stats 7
Having a problem with calculating medians in access 1
Converting Text Date to Real Date to # 8
Median Calculation in Access Reports 5

Top