Re: Crosstab Query Column Headings
ok diff question.
I have the below query and everytime i change it to Ascending in the design view not the code view Access encounters an error and must close. can you help me rewrite the code so it is ascending rather than descending.
SELECT Q.FTE_DATE_YM, (SELECT COUNT(*) FROM [qry_AvailableReportingMonths] Q1
WHERE Q1.FTE_DATE_YM > Q.FTE_DATE_YM)+1 AS Rank, "Month_0" & [Rank] AS Format1, Left([Format1],6) & Right([Format1],2) AS [Month]
FROM qry_AvailableReportingMonths AS Q
ORDER BY Q.FTE_DATE_YM DESC;