Finding the Median of a group of values

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

 

[[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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

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.