var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: creating a pivot table with vba
I'm working on a strange issue:
the fact is:
I've a table called xlstable3 that is done like this:
I'd just like to have a new table(called piv2) which stores the fields data like this:
The code I've tryed to solve the problem is:
The code error is 3075, missing operator!
Const c = "INSERT INTO piv2 SELECT CDPRD Distinct COUNT(CDPRD) As N FROM xlstab3 GROUP BY CDPRD"
if you are in need of more details feel free to ask!
thank you all in advance!!!
Last edited by jsirico; 02-28-12 at 11:49.