crosstab query sort by date

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
awesome, thanks!

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


c said:
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
Click to expand...
Click to expand...
 
Back
Top