Custom Format for crosstab headings

  • Thread starter Thread starter elena
  • Start date Start date
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
 
Also doable, indeed, with something like:


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



Vanderghast, Access MVP
 
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...
 
Back
Top