Finding the Median of a group of values

K

Kathleen

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

Calculate the median value before a specified list 0
Display weeks from a Milestone 0
Multiple Median Calculation 4
Calculating median in a group by query 4
Converting Text Date to Real Date to # 8
group and median 1
select queries that calculate the Median base on group by 1
Median If in Excel not working 4

Top