Sorting

[Josh]

I have a date field that I sort in my Query. The date
comes in the format 10/08/2003. When I sort ascending it
only sorts with the day and the month, it pays no
attention to the year. How can I get it to sort correct?

Thank You

 

[Pavel Romashkin]

Is the field you are using in Date/Time format, or perhaps Text format?
Dates should be stored in Date/Time format, which is in fact a
misrepresented (to you) numeric format. As such, it will follow the
sorting rules the way you expect.

Pavel