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

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

UNION and Crosstab query 5
Group by Range in Crosstab Query 4
Crosstab returns blank fields 6
Crosstab Returns Empty Fields 2
CrossTab Query Format 2
Showing Crosstab Totals Column in Chart 1
Crosstab qry not adding up 1
Crosstab By Month with only last 6 months data 6

Back
Top