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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to getting text labels to show up in scatter chart. 0
UNION and Crosstab query 5
Crosstab returns blank fields 6
Group by Range in Crosstab Query 5
Crosstab Returns Empty Fields 2
Crosstab qry not adding up 1
Single Query 6
How to avergage colums 7

Top