Calculate statistical median of multiple fields in a query

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.
 
J

Jeff Boyce

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>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top