Crosstab column heading dates in order?

[unc2plo]

I have a crosstab query that gives me sales for an item by day throughout the week.

The query has date as a column heading, item number as row heading and the sales as value.

The dates across the top are not coming out in order. For this week they come out 2/10, 2/11, 2/9. I don't care which direction they go as long as they are in order.

Is there a way to force them to sort correctly so I don't have to reformat the report everyday?

Thanks,
David

 

[Joe4]

In the CrossTab query, did you try to set the sort order of the field being used as a Column Header to Ascending?

Is the date field actually formatted as Date or Text? If it is actually a Text field, it will not sort properly as you have it entered (as it sorts it as a text field, where 2/9 will come after 2/10 and 2/11).

If you have a date field formatted as text, try changing how you enter the date to a "mm/dd" format, keeping the leading zeroes. Then 02/09 will come before 02/10 and 02/11 when sorted.