[Solved] Work around for Median in SQL Query

[enjoying28]

Hay I need some help. I have a 42k record table that I need the median price for a grouped set of records. Grouped by year then month and then the median (not the avg or mean) of them. I know base does not have a function for median does anyone have code for a macro or something that i could use as a work around?

Code: Select all

SELECT Median( "Price" ) AS "Price", "LstArea" AS "LstArea", YEAR( "CloseDate" ) AS "Year", MONTH( "CloseDate" ) AS "Month" FROM "main" "main" WHERE ( "LstStatus" = 'Sold' ) GROUP BY "LstArea", "Year", "Month"

thanks for any info.

[enjoying28]

Answer was given here http://www.oooforum.org/forum/viewtopic ... 9d4eefed67