calculating for median of data

[bsattel]

I am looking for a way to calculate for the median of
data.
Example:
I have data being imported into my database from several
files (at the most 9 files) with two headers, "data1 and
data2". There are 170 records in each file. I want to
chart the median of data1 and data2. How do I calculate
the median?
The files are set up in this way:
Data1 data2
1 .9
2 1.8
3 .87

 

[DBS]

ACC2000: Reporting the Median Value of a Group of Records
http://support.microsoft.com/default.aspx?scid=kb;en-
us;209244&Product=acc2000

Hope that helps...

DBS

 

[bsattel]

I guess I didn't tell you all the details. The
information you gave me is good, but I need to get the
median across a row not a column. Is this possible?