Medians in Crosstabs (Access (any version))

[johnhutchison]

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.

[HansV]

You'll have to use the two-step method.

Added: the first query doesn't need to be a group by query.
In the crosstab query, you can also use First instead of Max.