Trying to get Median value for a dataset in Access

This is my first post so hopefully I don’t mess anything up.

I’m using Microsoft Access to build a database of chemicals occurring in several different environmental sample types (water, sediment, fish species, etc). I ran a query that required some SQL to return the average Result Value sorted by Chemical Name and Sample Type, and it worked out just fine. My collaborators would also like to see the Median of Result Value sorted with the same criteria (i was able to add Min and Max values pretty easily, but median isn’t one of the choices in Total:). Is there any way to do this? I have the DB open so I can share screencaps or code if needed.

[link] [comments]

Posted on