F Fred Loh Oct 26, 2008 #1 is it possible to have a row of totals (at the last row) for columns in a crosstab? thanks for your reply!
is it possible to have a row of totals (at the last row) for columns in a crosstab? thanks for your reply!
R Rick Brandt Oct 26, 2008 #2 Fred said: is it possible to have a row of totals (at the last row) for columns in a crosstab? thanks for your reply! Click to expand... 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".
Fred said: is it possible to have a row of totals (at the last row) for columns in a crosstab? thanks for your reply! Click to expand... 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".
T Tom van Stiphout Oct 26, 2008 #3 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
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
T Tom van Stiphout Oct 27, 2008 #4 Upon re-reading the OP's message you had the correct solution. -Tom.
