Custom Format for crosstab headings

E

elena

Hi, All
I have following statement in crosstab:
PIVOT Format([fld2],"mmm") In
("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");

Is it possible to customize headings for following output"
Jan(table1) Feb(table1) ... etc
please, help
thank you
 
M

Michel Walsh

Also doable, indeed, with something like:


PIVOT Format([fld2],"mmm") & "(table1)" IN
("Jan(table1)", "Feb(table1)", ..., "Dec(table1)")



Vanderghast, Access MVP
 
E

elena

Yes, it works great!
thank you Michel

Michel Walsh said:
Also doable, indeed, with something like:


PIVOT Format([fld2],"mmm") & "(table1)" IN
("Jan(table1)", "Feb(table1)", ..., "Dec(table1)")



Vanderghast, Access MVP



elena said:
Hi, All
I have following statement in crosstab:
PIVOT Format([fld2],"mmm") In
("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");

Is it possible to customize headings for following output"
Jan(table1) Feb(table1) ... etc
please, help
thank you
Click to expand...
Click to expand...
 
Top