If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Median
Hi!
Are there ways to calculate the Median in Access, please? Thanks in advance an |
#2
|
|||
|
|||
Median
There's this KB article:
http://support.microsoft.com/kb/95918 or you could also use automation on the Excel Median function. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "an" wrote in message ... Hi! Are there ways to calculate the Median in Access, please? Thanks in advance an |
#3
|
|||
|
|||
Median
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 "Arvin Meyer [MVP]" wrote: There's this KB article: http://support.microsoft.com/kb/95918 or you could also use automation on the Excel Median function. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "an" wrote in message ... Hi! Are there ways to calculate the Median in Access, please? Thanks in advance an . |
#4
|
|||
|
|||
Median
On Sat, 1 May 2010 13:32:01 -0700, an wrote:
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. -- John W. Vinson [MVP] |
#5
|
|||
|
|||
Median
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 "an" wrote in message ... 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 "Arvin Meyer [MVP]" wrote: There's this KB article: http://support.microsoft.com/kb/95918 or you could also use automation on the Excel Median function. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "an" wrote in message ... Hi! Are there ways to calculate the Median in Access, please? Thanks in advance an . |
Thread Tools | |
Display Modes | |
|
|