A query in MS-Access is creating a table, say tbl_WeekNums, which has exactly 2 fields and exactly 52 records. The values in field "YYYYWW" are sorted in descending order. The values in the other field are "calculated" values based on the values in field "YYYYWW".
The values of column "Week Num - Year" are used as the horizontal column headings (not the vertical row headings) in a CrossTab query. However, the column headings in the CrossTab query are getting "auto-sorted" as
Is there any way to get these column headings, in the CrossTab query, sorted like below?
