I'm trying to create a query which calculates medians. The source is simply a list of numbers (field 2), grouped into several different categories (field 1). I want to find the median for each category.
I've been searching around for help with this query, but everything I've found seems to involve huge amounts of code, which isn't exactly one of my strenghths. Does anyone know of a simple way of programming this query, preferably using either the query window or sql?
Can you post part of the table or query? I'm not quite sure how you have your numbers arranged with your categories. If not, give an example of a few entries in your table so I can determine the structure.