Does any one know how to sum two cells from crosstab query?

[sk88]

I have a crosstab query which shows me something like:

Activity Quarter1 Quarter2 Total
Call 2 1 3
Visit 3 1 4
Home 4 2 6




and I want to add another row in the query itself or a new query to SUM the Visit and Home.. Like for example:

Visit+Home 7 3 10



Is it possible to do that?

[rpeare]

do you want to retain the home and visit lines independantly and also have a home and away line?

[sk88]

do you want to retain the home and visit lines independantly and also have a home and away line?

Thanks rpeare.
I managed to figure out what I want and create that.