Is it possible (and has anyone done it yet) to create additional aggregate functions in MS Access (I'm using 2007)? In particular, I want to create "Group By" queries that calculate the Median of each group. I have a median function that works on entire columns (or subsets) individually, but it doesn't work as a aggregate function like AVG, SUM, COUNT, etc. do.
February 3, 2009 5:30 PM
October 27, 2009 2:39 AM