(14/12/2019, 14:41)berduş yazdı: Where den sonra kullandığınız koşulları and baglaciyla birlestirebilirsinizSanki Olmadı Hocam
SqlSirala = " SELECT odeme.Kradsoyad, odeme.KrTc, odeme.Kvadsoyad, odeme.KvTc, odeme.odmTrh, odeme.KrTcOdmTrh, odeme.kimde, " & _
" [Kradsoyad] & '* ' & [KrTc] & '*' & [Kvadsoyad] & '*' & [KvTc] AS Arama " & _
" FROM odeme " & _
" WHERE ((([odmTrh]) Between " & CLng(Me.Metin79) & " And " & CLng(Me.Metin82) & " and " & [Kradsoyad] & '* ' & [KrTc] & '*' & [Kvadsoyad] & '*' & [KvTc]) Like '*' & [Forms]![giris]![gecici] & '*')) " & _
" ORDER BY odeme.Kvadsoyad;"
Böyle de Olmadı
SqlSirala = " SELECT odeme.Kradsoyad, odeme.KrTc, odeme.Kvadsoyad, odeme.KvTc, odeme.odmTrh, odeme.KrTcOdmTrh, odeme.kimde, " & _
" [Kradsoyad] & '* ' & [KrTc] & '*' & [Kvadsoyad] & '*' & [KvTc] AS Arama " & _
" FROM odeme " & _
" WHERE ((([odmTrh]) Between " & CLng(Me.Metin79) & " And " & CLng(Me.Metin82) & ")) " & _
" and &((([Kradsoyad] & '* ' & [KrTc] & '*' & [Kvadsoyad] & '*' & [KvTc]) Like '*' & [Forms]![giris]![gecici] & '*')) " & _
" ORDER BY odeme.Kvadsoyad;"