Summary row in crosstab query?

  • Thread starter Thread starter Danny
  • Start date Start date
D

Danny

Howdy.

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

Thanks.

Danny
 
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.
 
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
 
I'll give the union query a try - thanks.

KARL DEWEY said:
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.
Click to expand...
 
Back
Top