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