dao sort descending.. how?

[Thai]

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

Thanks,
Thai

[JasonGS]

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

' 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?

[Thai]

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

Thanks,
Thai