Ordering a recordset.....assistance please !

[sjf]

I create a recordset from a database, no probs, then I want to order it so one particular value falls at the last position in the recordset....anyone have any ideas?
sjf

 

[mrichards]

Why? you can display it in any order you want? But if you want you declare the order in the sql rather than

"SELECT Table1.* FROM Table1"

use


"SELECT Table1.field3, Table1.field2, Table1.field1 FROM Table1"

Mark