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