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