Relative column headings in Crosstab when used in Chart

A

Alex

Following is the SQL for a crosstab query that I use as the record source for
a chart in a report. How can I make the M0 - M11 format to mmm/yy in my
chart? Thanks.


TRANSFORM Max(Super_D1Tots_Q1.[Day 1 Performance]) AS [MaxOfDay 1 Performance]
SELECT Super_D1Tots_Q1.[RCD LOC]
FROM Super_D1Tots_Q1
GROUP BY Super_D1Tots_Q1.[RCD LOC]
PIVOT "M" & DateDiff("m",[forms]![Pick_Super_Chart]![cmdBegin],[NewDate]) In
("M0","M1","M2","M3","M4","M5","M6","M7","M8","M9","M10","M11");
 

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

2nd post - Crosstab query column headings 2
MS Query 2
Deleting/Clearing duplicate range of cells 8
Limiting results from one side of a join conditionally 1
2D graph with label 1
Help with Code 3
column headings in CrossTab Qry? 2
Count blank cells since last entry 2

Top