Summary row in crosstab query?

[Danny]

Howdy.

Is it possible to add a row to a crosstab query that totals each column in
the query?

Thanks.

Danny

 

[KARL DEWEY]

Yes, create a totals query of the data with a calculated field containing "~
Total" (I am not sure but I think the tilda sorts out after 'Z') in the same
field as will be the row data.
Then use a union query to combine a select query and the totals query.
Use the union query for the crosstab query.

 

[John Spencer]

Do you mean you want a total of the row (going across)? The answer is Yes.
Do you mean you want a total for each column (going down)? The answer is No.

Well, you could get column totals (vertically) by using a Union query of the
crosstab query and another query that uses the crosstab as a source to get a
grand total of each column.


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[Danny]

I'll give the union query a try - thanks.

Yes, create a totals query of the data with a calculated field containing "~
Total" (I am not sure but I think the tilda sorts out after 'Z') in the same
field as will be the row data.
Then use a union query to combine a select query and the totals query.
Use the union query for the crosstab query.