You should never calculate the average value of anything without also calculating the median value. Chris Weber explains why and gives you a clean, step-by-step method for deriving the median value from any numeric series. Unlike other published methods, Chris' method uses no temporary tables or custom functions–all you need is a single query. This article comes from our Smart Access collections http://www.vb123.com/kb/200504_cwmedian.htm
Why not purchase a collection and help fund this monster Access website.