I'm not a complete novice at databases and I could certainly do this in Excel but cannot
seem to get it to work in Access:
I have a query that sums values for products the results of which look like this (though there are actually >100 sum columns):
Pname___Asum____Bsum_____Csum...