Median Function

[Lynn63]

I need to calculate the median of a group of numbers in a query. Excel does this nicely, but I cannot find a function in Access. Does anyone out there know where I can get my hands on such a function to use in Access? Thanks in advance.

 

[pcs]

try this link:
http://support.microsoft.com/support/kb/articles/q95/9/18.asp?id=Q95918

you might also want to search the KB for:

Statistical Median

to see other options.

hth,
al

 

[Lynn63]

Thanks, it worked!

 

[PearlGI]

I realise that you've already solved your issue, but as an alternative for future use, refer to the Example 1 in this link:
http://support.microsoft.com/support/kb/articles/Q153/7/48.ASP

This uses the Excel median function rather than 'reinventing the wheel'.

Just feed the results of your query into an array and then refer to this array in the function.