Hello can someone explain to how to sort descending on a dao recordset?
Thanks,
Thai
Printable View
Hello can someone explain to how to sort descending on a dao recordset?
Thanks,
Thai
You can use your SQL statement to sort descending...
you get the point right?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
we're using the control, is there a way using the recordset object to do this?
Thanks,
Thai