Crosstab query date sort

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top