Sort an mdb datatable through VB6 code

Hello,

I would like to know if i can sort a table using (SQL?) and change the index of each row. The reason is that I refer to this index to display data, and i'd like to have it sorted.
E.g., now i use a string like "SELECT * From Customers WHERE AA=" & Cur_Row, where Cur_Row is an integer that is set programmatically, and AA field is unique index.
Is there a way? Or an alternative to overcome this?

You could use the ORDER BY clause to sort a table according to a specific column or columns.

yeah, dee-u is right. :-)