Soring dates in a crosstab

[Nicolayd]

Hi

I have created a crosstab in a query, and would like the dates which are held in columns to be alphabetically sorted. How is this possible please.

Regards

Nicola

[vicrauch]

within the query create a "calculated" field. Use the date field as the parameter to the Format() function. So, if you wanted the date field sorted alphabetically by month, here would be the format:

Format(myDate, "mmm")

For today's date of July 12, 2011, this function will return the string "Jul" which you could then use in a displayed, or non-displayed field, but set the field to be sorted. If you want the name of the day of the week, you can use "ddd" in the function rather than the "mmm"