Sorting Problem in a query!

[mohsinhq]

I have a crosstab query which has the week number as the row heading (Week 1 to 53)

The problem is that if i try to sort by Week then this is how it appears...

1
10
11
12
...
19
2
20
21
...

and so on..

anyone knw how to fix this??

 

[sehmke]

Ranking weeks (or months)

I had the same problem with months. I have a table with sales per month. In that table I have defined the month field as Double, Format: 00. That way it always appears as 01 (for january) 06 (for june) or 11 (for november). If you then sort on this field in a query, the ranking is correct: 01, 02, ... 09, 10, 11 etc.

Good luck.