I have a small system that is running on access 2010 and lower
It currently has a form that uses pivot tables.
Therefore I'm getting each row and each column with totals.
The user has now moved to access 2016 an lo and behold they've stopped using pivot tables (expletive deleted).
I thought I'd use a crosstab query but although I can see how to get the rows totalled, I can't work out how to get the columns totalled.
Any ideas how I can or whether I should be using a totally different method?
TIA.
It currently has a form that uses pivot tables.
Therefore I'm getting each row and each column with totals.
The user has now moved to access 2016 an lo and behold they've stopped using pivot tables (expletive deleted).
I thought I'd use a crosstab query but although I can see how to get the rows totalled, I can't work out how to get the columns totalled.
Any ideas how I can or whether I should be using a totally different method?
TIA.