Microsoft Access - How to sum each column values in Crosstab query?

Asked By kibika on 17-Apr-13 05:07 AM
I would like to sum each column individually in a crosstab query and display the sum at the bottom of each column. The values are in currency format. Is it possible to do this?
e.g.

Name          Month1         month2     month 3 ............................. month 15
Kibika         2000           3000       4000       ............................. 5000
wanjala         3000           4000       5000   ..................................6000
       Total      5000           7000       9000   ................................ 11000

Any help will be greatly appreciated.


thanks in advance.

kibika