In my crosstab query, field Period acts as a column heading. Data in the field is based on Medium Date Format - dd-mmm-yy . I have formated the query field to display results in "mmm yyyy" format. However, the columns are displayed in alphabetical order eg. Aug 2003, Jul 2003, Jun 2003, Sep 2003. If i change the format to "mm yyyy", the results are in correct order - 06 2003, 07 2003, 08 2003, 09 2003. What am i doing wrong here ?

Vladimir

__________________
Vlad
Sydney, Australia

You're not doing anything wrong. The Crosstab query sorts according to string labels. In the first instance, the names of the month were used and in the second, the numbers were used. You could create a crosstab with two row headings. The first row heading is your month number and the second row heading is the name of the month. This will force the the CrossTab to sort on the numeric values but also display the month information.

- Mark M -