RS.Open "SELECT * FROM [work] WHERE [feld1] LIKE '" & Trim(Text1) & "'", Cn, adOpenStatic, adLockPessimistic RS.Open "SELECT * FROM [work] WHERE [feld1] LIKE '%" & Trim(Text1) & "';", Cn, adOpenStatic, adLockPessimistic RS.Open "SELECT * FROM [work] WHERE [feld1] LIKE '" & Trim(Text1) & "%';", Cn, adOpenStatic, adLockPessimistic RS.Open "SELECT * FROM [work] WHERE [feld1] LIKE '%" & Trim(Text1) & "%';", Cn, adOpenStatic, adLockPessimistic
أين أضيف جملة الفرز حسب الحقل
في كل جمل الاستعلام السابقة
"# ORDER BY [feld1]"
