Median

[an]

Hi!

Are there ways to calculate the Median in Access, please?
Thanks in advance

an

 

[Arvin Meyer [MVP]]

There's this KB article:

http://support.microsoft.com/kb/95918

or you could also use automation on the Excel Median function.

 

[an]

Thanks for reply.

You sample apllies to:

Microsoft Access 1.0 Standard Edition
Microsoft Access 1.1 Standard Edition
Microsoft Access 2.0 Standard Edition
Microsoft Access 95 Standard Edition
Microsoft Access 97 Standard Edition

:-(

an

 

[John W. Vinson]

Thanks for reply.

You sample apllies to:

Microsoft Access 1.0 Standard Edition
Microsoft Access 1.1 Standard Edition
Microsoft Access 2.0 Standard Edition
Microsoft Access 95 Standard Edition
Microsoft Access 97 Standard Edition

Haven't tested it but the first code (not the 1.0) should work fine in later
versions. Try it.

 

[Arvin Meyer [MVP]]

It's an older article, but the code will work in ALL versions of Access.
Additionally where it calls for a Tablename, I'm pretty sure that you can
use a saved query.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access