P
Peter
I put the result into an array getting from another db, the arrangement
should not be changed,
MemberList = "'007910', '006853', '007965'"
SQL = "Select MemberID, name From Member"
SQL = SQL & " Where MemberID In (" & MemberList & ")"
Set rs = GetMdbStaticRecordset( "Member.mdb", SQL)
While not rs.eof
........ Wend
But the order changes to 006853 first, then 007910....007965
Is it possible to use "order by" to keep the arrangement
SQL = SQL & " Order By '" & MemberList & "'"
Please help !
should not be changed,
MemberList = "'007910', '006853', '007965'"
SQL = "Select MemberID, name From Member"
SQL = SQL & " Where MemberID In (" & MemberList & ")"
Set rs = GetMdbStaticRecordset( "Member.mdb", SQL)
While not rs.eof
........ Wend
But the order changes to 006853 first, then 007910....007965
Is it possible to use "order by" to keep the arrangement
SQL = SQL & " Order By '" & MemberList & "'"
Please help !