Crosstab query date sort

  • Thread starter Thread starter Tracy
  • Start date Start date
T

Tracy

In my crosstab query, the short date sorts like:
6/1/04, 6/14,04, 6/20/04, 6/9/04 which although is
textually correct does not represent the correct order for
a date. How do I get it to sort the date in dtm order.
The field is formatted as date/time.
 
Back
Top