How do I build an expression to get the median?

[Cathy Reidy]

I'd like to build an expression in a query that calculates the median of some
cells in the same record/row. MEDIAN () doesn't seem to exist in Access.
Any help?

 

[Jeff Boyce]

Cathy

"cells in the same record/row" implies that your data/table is a ...
spreadsheet! This is NOT a good thing in a relational database...

Is there a reason you don't just export your data to Excel and use the
MEDIAN() function there?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Cathy Reidy]

Jeff,
Thanks for responding. Well, I've got 15000 records - fish species - and
I'm pulling attributes for each species code from many Access tables. One
table has median age values for some species, another table has min and max
age. I'ld like to query so that if there is a median age value, then use
that, and if not, then calculate the median from the min and max values in
the other table. So I guess when I say "same record/row", I mean same
species code. Does this make sense? Anyway, I could export, but am wanting
to learn how to avoid exporting everytime I hit a wall like this.

Ideas? Thanks!

 

[MikeJohnB]

try Doug Steele's Site

http://www.accessmvp.com/DJSteele/SmartAccess.html

Look for

"October 2005: An average column: I mean, what mode is your median?"

Hope this helps Cathy?

Best Regards Mike B
--
An Engineers Prayer:
At the very end of the day,
when all else fails,
you have tried all,
you have shouted at and blamed the innocent,
and asked everyone you know,

READ THE INSTRUCTION MANUAL.

 

[MikeJohnB]

Added Cathy, If you are viewing this discussion group the same way I am,
there are two boxes above which are two search fields, a search for Median
a=in access datbase will give you a load of hits on Medians and calculating
in Access.

I Hope this helps further?


--