[Q] sắp xếp data

[namtuocbongtoi]

Dim RSSTUDENT As Recordset
Dim DBSTUDENT As Database
DataBaseFile = ten file
databasepassword = password
Set DBSTUDENT = OpenDatabase(DataBaseFile, False, False, ";pwd=" & databasepassword)
Set RSSTUDENT = DBSTUDENT.OpenRecordset("SELECT * FROM danhsach", dbOpenDynaset)


có lệnh nào để sắp xếp các record trong danhsach không(ví dụ xếp theo field"tuổi")

[come2one]

Bạn dùng lệnh Order By <field> đi:
"SELECT * FROM danhsach Order By Tuoi"

[White_Rose]

"SELECT * FROM danhsach Order By Tuoi"

--> sắp xếp giảm

"SELECT * FROM danhsach Order By Tuoi DESC"