Calculating a median in a query

[Emlyons]

Hello,

I am completely new to Access. I am running a query but need to take the median value of observations in one of my tables. I've tried creating an expression but it is not working. I've also done some internet searching for a step by step guide on how to do this, but it's all jibberish to me! Could someone who has a few minutes to spare please post some sort of quick step by step guide on how to get median values in language that a novice like me can understand? Thank you so much!!!

[Mac Campbell]

I found the Microsoft site has exactly what you need.
The location is http://support.microsoft.com/kb/210581

[Mac Campbell]

Hello,

I am completely new to Access. I am running a query but need to take the median value of observations in one of my tables. I've tried creating an expression but it is not working. I've also done some internet searching for a step by step guide on how to do this, but it's all jibberish to me! Could someone who has a few minutes to spare please post some sort of quick step by step guide on how to get median values in language that a novice like me can understand? Thank you so much!!!

I found the Microsoft site has exactly what you need. You don't really need to be intimidated - just read the Summary to make sure you are getting the right definition of median. Then go to the modules section and click "New". Then click "Tools" in the window you just opened and select references (as it says to in the "More information" section.) You do this by scrolling down the references list until you find the Microsoft DAO 3.6 Object Library. Put a check in the box to the left by clicking on it. Then you can cut the "Function Median ..." code right from the Microsoft window and paste it into the open module window (as it says in step 2 of the MS website). Close your module. I found its best to close right out of access at this point in order to ensure that the module is saved and appears in the modules window. You can save the module as "Module 1" or "Median" if you like. When you reopen Access you should open the module again and see that the code you put in is still there. While it is open check your references again to see that the Microsoft DAO 3.6 Object Library check box is selected (check mark). At this point, you can read the section "How to Use the Median() Function" on the MS site.

The Microsoft location is MS Median info at:

Hope this helps.

[MMcCarthy]

Here is another question on this issue which may help.

http://www.thescripts.com/forum/thread608740.html