Access 2000 'date sort'

  kumarisblue 11:51 01 Jul 2005

I have input dates into my database table in the short date formula for example: 01/07/2005. Can anyone tell me how to sort these dates in a chronological order? If i try to sort them as they are they just appear in ascending order using the first 2 numbers for example using the above date layout '01'. I have several different years on the database. How can the years and dates be sorted chronologically???

Help much appreciated thankyou!!!

  Access genu 13:31 01 Jul 2005

it sounds like you are recording the dates as text. This is why they are being sorted 01/01, 01/02 etc.

The easiest solution would be to see if you can convert the field in the table to a date field.

If this is not possibel then you could try either the format, or convert function in the query to convert the field to a date, then sort on that.

If you need any help on the convert or format function please post back here.

  wee eddie 14:52 01 Jul 2005

Display Database as a "Table"

Highlight the date column by Left Clicking it.

Right Click will open a box of which the top 2 alternatives are Sort Ascending & Sort Descending.

Click on whichever you want

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Honor 9 Lite review

How Social Media has Propelled Political Graphic Design and Art in the Last Decade

The best kids apps for iPhone & iPad 2018

HomePod d’Apple : date de sortie, prix et fiche technique