I have a crosstab query that is using a date field for the column heading. I need the columns to sort in ascending order, however, this isn't working properly.

For example, the column 01/01/2004 is before the column 04/30/2003

Any ideas?

What is the date format/date separator on your machine? One solution is to use the Format function to display dates as strings in the yyyy/mm/dd format:

Format([MyDate], "yyyy/mm/dd")

Make sure you use 4-digit years in case you have date prior to 2000.