I am just starting on a new job where I need to calculate lots of medians.
I have got median function from <post#=301021>post 301021</post#> , and can get it to work OK in queries.
I attach a sample where it works in group by queries with one and two group by fields. Can I get it to work in a crosstab query?
In the attachment 'qryMediansCrosstab' does not work. It was made by turning 'qryMediansGroupByTwoFactors' into a crosstab.
Can anyone suggest a modification to this query that does work?
I have a workaround if I need it. 'qryMediansAge_Crosstab_twosteps' does work. It is a crosstab query that takes the results of 'qryMediansGroupByTwoFactors' and crosstabs them.