Median & Mode

[Guest]

Does Access have an aggregate function for Median and Mode like it does for
Average? If not, is there a SIMPLE way to calculate the Median and Mode in a
report? Thanks.

 

[Jeff Boyce]

As far as I know, Access does not have a "native" function for these two
measures of central tendency. But if you use a code module and References,
you should be able to reference these functions from the Excel library.

If this doesn't work, a generic description (?p-code?!) of Median is --
"line 'em up in order, take the one in the middle (or average, if there are
an even number"). The Mode is "that value which happens most frequently" --
note that a set of numbers could have more than one Mode.

Good luck!

Jeff Boyce
<Access MVP>, and former stats instructor