Enable Cross tab column totals with vba

[john134]

I have a crosstab query with years as the columns and names as the rows and donations as the values for each person for each year.

I want to total the year columns. In view mode I can easily due that by clicking on Totals on the Home menu, going to the cell for this value and clicking on sum. But, how do I "click on Totals" from the Home menu automatically with vba code?

John134

[ranman256]

what is VBA to do?
the query will pull the data and do the sums in columns. Row totals in the Total column.
Are you wanting Column totals?

[john134]

Yes, I want to total the year columns.

[aytee111]

The usual method is to create a second query that totals by year. Then a third query using UNION which will join both queries together. Get the sort order right and the totals will be displayed as the last row.

[john134]

I solved it by exporting to excel and then running a macro to get the column totals.