crosstab query sort by date

[Guest]

In my crosstab query I have the column heading set as a date field. I also
have sort, ascending selected. However, the dates are in order except that
single-digit dates appear after the teens and twenties. eg. 12/9/2004 is
after 12/20/04, presumably because it's sorting by the first digit of the day
(9 vs. 2) rather than 9 vs. 20.

Is there any way to fix this problem?

Thanks,
C

 

[Edward G]

substitute this expression for the default:
Expr1: Format([yourDatefield],"mm/dd/yy")

 

[Guest]

awesome, thanks!

substitute this expression for the default:
Expr1: Format([yourDatefield],"mm/dd/yy")

In my crosstab query I have the column heading set as a date field. I also
have sort, ascending selected. However, the dates are in order except that
single-digit dates appear after the teens and twenties. eg. 12/9/2004 is
after 12/20/04, presumably because it's sorting by the first digit of the day
(9 vs. 2) rather than 9 vs. 20.

Is there any way to fix this problem?

Thanks,
C