Crosstab query
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
|