nelsonpang

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

MikeJ

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.)