If you are limited to the advanced recordset view you can manually add in the sorting by adding an order by clause to the end of your query, it might look like this:
SELECT * FROM table
........
........
ORDER BY 'column to sort by' ASC
This would sort by the column specific in ascending order.