Median

[roberemok]

Can I do an Median Function in Access? I do not see in the the built in functions?

Thanks

 

[raskew]

A search of this forum on 'median' returns 37 threads. Try it, you'll like it.
I'm sure one of them will meet your needs.

Bob

 

[roberemok]

Where is the love and the personal touch? (just kidding)

I did the search before and it does not answer my exact question.

Is there a Median Function in Access? All searching brings up is what appers to be Custom Functions. Is this the only way in Access?

Can I do this outside of VBA?

 

[raskew]

Hi -

The short answer is: There's not a built-in Median() function in Access. However, it's not a difficult UDF (user defined function) to create. Try searching on MedianX, which will return several possible solutions.

Bob