Help calculating MEDIAN

[ausmoran]

I have a SQL table in which I have home sales records with the following fields:
closingDate County SalesPrice

I have been attempting to figure out a way to calculate the MEDIAN for the sales price, broken down by county for a specific date range (year-to-date).

Is there a way to accomplish this in access? Any help you might be able to provide would be greatly appreciated. There are approximately 50,000 records spread out over 60 different counties.

Thanks in advance for any assistance that you may be able to provide. I am an extreme novice, so I'm hoping for a relatively easy solution.

Thanks very much!

-Austin

 

[DJN]

There is an article on the Microsoft Knowledge base that may be of some help. Just follow the link.


http://support.microsoft.com/default.aspx?scid=kb;en-us;q210581


David