Calculate statistical median of multiple fields in a query

  • Thread starter Thread starter Ken D
  • Start date Start date
K

Ken D

In previous responses to this same question, I have
seen multiple examples of functions that calculate the
statistical median of a single field/column in a query.

I am interested in creating a calculated field in a
query that calculates the median across multiple fields
in a single row. For example, I have a query with the
fields q1, q2, q3 and q4. If I wanted to find the "Sum"
of these four fields, I would simply write the expression
Sum=[q1]+[q2]+[q3]+[q4]. How do I find the "Median" of
the same four fields? Thanks in advance.

Ken D.
 
Ken

I'm inferring from your description that you have multiple fields with the
same type of data (else why would you want to sum the values, or find a
median?).

This is a spreadsheet design, but doesn't work well in a relational database
(Access). You may want to read up on normalization before pursuing this
further.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top