Excel has a wonderful function known as the “Median Function” that unfortunately is not available in Access. I know there must be a way to get the median value for a group of records in my database, but I’m not sure how to implement.
In my attached database, ‘tblRawData’ contains my raw data, and ‘tblMedianResults’ reflects what my expected results would be after using the “median” function (if it were available). If you look at ‘tblAvgResults’ compared to my raw data, you’ll see why I do not want to utilize the “Average” function.
Here’s a thread
pertaining to this topic, but I wasn’t able to make heads or tails of it. Any direction you experts could provide would be greatly appreciated. Thanks!