I have a table with 2 fields:
Each account will have several Payment intervals which were determined in a prior step by finding the difference in time between the payment dates.
I want to compute the MEDIAN of the payment intervals.
I can do a TOTALS query and get the Average.
How do I also get the MEDIAN for each AccountNumber SubTotal?
Ideally I'd like a subquery that I could place into a cell in the Totals query.