Howdy Folks...

So, I have a calendar program I have written which basically stores a number of entries on any given date, as set by teh date/time picker component.

Basically, this is all written to an access db I use for my program output and re-read later.

The idea is:

1) A DAO query is set up to open the db and read in all the DATES to a list box
2) User clicks on any given date, as shown in the listbox
3) By the use of hte ID, it shows any events for the date, as per whats stored in the database.

All I Want to do, is sort that list of dates in my listbox (Which comes from the database) by DATE i.e if I had say:

19/01/2008
25/02/2008
30/01/2009
..it would go in that order as its 3 dates oldest to newest....

As things stand just now, I get:

19/01/2008
30/01/2009
25/02/2008

...can someone tell me how I can get it to sort on DATE, based on oldest to newest???

Cheers