How to Make the ascending in the Table

can i using recordset to set fields ascending??
or must be using SQL to set it?

If u know the answer Pls reply me faster !!
Thank you,
Merci
:huh:

You can use the Sort property of the Recordset. Notice though, this will not rearrange the records, it will just let you access them in the sorted order. Check out this property in MSDN. (Of course, you could use the SQL - ORDER BY and ASC statements too.)