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

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.