dao sort descending.. how?

Hello can someone explain to how to sort descending on a dao recordset?

Thanks,
Thai

You can use your SQL statement to sort descending...

Code:

---

' Sort by "field", descending...
SELECT * FROM table WHERE field = 'value' ORDER BY field DESC
' Sort by "field", ascending...
SELECT * FROM table WHERE field = 'value' ORDER BY field ASC

---

you get the point right?

we're using the control, is there a way using the recordset object to do this?

Thanks,
Thai