Column Totals In Crosstab Queries

  • Thread starter Thread starter mcl
  • Start date Start date
M

mcl

Is it possible to do column totals as well as the default row totals? I
tried to draw on how it does row totals in design view by adding the same
type of thing for columns and the ensuing message essentially slapped my
hand.
 
Not possible in a single crosstab query. Either display your results in a
report where you can total or create another similar crosstab without
some/all of the Row Headings and then union the two crosstabs together.
 
Back
Top