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?
Thanks.
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?
Thanks.
This may be useful
He has a reference to ACC2007
http://allenbrowne.com/ser-67.html
Thanks orange, will check it out.
According to the article, it seems that this can only be done in Access 2007, by going to Home->Records and selecting "Totals" (the E shaped sum sign). However this is not a dynamic solution, i.e. you have to manually do this for each column each time you run the report.
Do you know of any way to do this dynamically by modifying the SQL code so it does this automatically each time it's run, or is this outside the possibility of Access?
Thanks!