mode and median in Access reports - TechRepublic
General discussion
February 7, 2002 at 03:59 AM
john_wills

mode and median in Access reports

by john_wills . Updated 22 years, 10 months ago

I can get mean and standard deviation of a column in an Access report by calling built-in functions. There seem to be no parallel functions for mode and median. How do I produce these statistics? I have an idea it may be doable via SQL, but the necessary grouping would lose me my output for the individual cases.

This discussion is locked

All Comments