crosstab fa

[Fred Loh]

is it possible to have a row of totals (at the last row) for columns in a
crosstab?

thanks for your reply!

 

[Rick Brandt]

is it possible to have a row of totals (at the last row) for columns
in a crosstab?

thanks for your reply!

Probably can be done with a UNION query, but it would be a lot better to do
so in a report which has such functionality without getting "creative".

 

[Tom van Stiphout]

Rather than the final union query, create a new select query, select
the two previous queries and join them by the PK. Select all columns
from the first, and the sum column from the last.

-Tom.
Microsoft Access MVP

 

[Tom van Stiphout]

Upon re-reading the OP's message you had the correct solution.

-Tom.