flexible crosstab query

[tiak]

i would like to have a crosstab query functioning like a pivot table. the fields names need to be introduced dynamically from a combo box on a form e.g.combo1 becomes the rows and combo2 becomes the columns. is this possible? thanks

 

[Jon.N]

Access queries cannot calculate column totals. Crosstab queries cannot be sorted on the calculated columns. Basically they give you a calculated value in the row-column grid and a row total.