Sorting a form's records in order by date.

[slikbaz]

Hi,

Basically I have a form which displays data that is stored in a table. One of the fields that is displayed has dates entered into it. Now I need a button which, when clicked, sorts the records in the form into ascending/descending order from the earliest date to the latest.

A similar problem was solved here:

http://www.tek-tips.com/viewthread.c...343020&page=86



However when I tried that, it only works for text-based fields and not for dates.

Also, I was wondering how to sort numbers into order, from lowest to highest and highest to lowest with no negative numbers present.

Any help appreciated

Slikbaz

[maximus]

here is a small example I have a table called valueTable with a Date Field LDate. I have attached this piece of code to the OnClick event of a Command button to Filter my Form in the assending Order of date. I have used strSQl as the Record source to sort the form by LDate.

Dim strSQL As String
strSQL = "Select * From valueTable Order By LDate"
Me.RecordSource = strSQL

[weekend00]

can't you do it by me.orderBy ?
e.g.
me.orderBy="MyDate asc"
me.orderbyon=true

[maximus]

Absolutely it can be done by using me.orderBy. In fact I think is much more easier that way.