Finding Median in Query

[randolphoralph]

I currently have a Query set to give me the Average of # Days, and I am needing to change it to show me the Median and not the Average.



How would I do this?

I have included my SQL below.

SELECT [1 All Import].MSTSF, [1 All Import].[TOS Code], [1 All Import].[Rendering], [1 All Import].[ Name], [1 All Import].Net, Count([1 All Import].[Ref #]) AS [CountOfRef #], Count([1 All Import].[Apt Date]) AS [CountOfApt Date], Avg([1 All Import].[# Days]) AS [AvgOf# Days], Avg([1 All Import].[Distance]) AS [AvgOfDistance]
FROM [1 All Import]
GROUP BY [1 All Import].MSTSF, [1 All Import].[TOS Code], [1 All Import].[Rendering], [1 All Import].[Name], [1 All Import].Net;

[llkhoutx]

Count the records and look in the middle of the recordset.