Column Totals In Crosstab Queries

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.
 
D

Duane Hookom

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top