ozaman kuralı aşağıdaki gibi değiştirsek yani 'TMŞ';'TMŞA' ve 'DPA' olarak 2ye ayırsak ve 'TMŞ';'TMŞA' için 2 kuraldaki not like ları and ile birleştrsek
SELECT Sheet1.*
FROM Sheet1
WHERE (((Sheet1.AnaIsEmri) Is Null) AND ((Sheet1.ArizaTipi)='AG') AND ((Sheet1.KesintiNedeni)='DPA') AND ((Sheet1.SebekeUnsuru) Not Like '*0 Çıkışı*' And (Sheet1.SebekeUnsuru) Not Like '*M01*' And (Sheet1.SebekeUnsuru) Not Like '*KORUMA*' And (Sheet1.SebekeUnsuru) Not Like '*KOUMA*' And (Sheet1.SebekeUnsuru) Not Like '*D.TR*' And (Sheet1.SebekeUnsuru) Not Like '*DAHİLİ*' And (Sheet1.SebekeUnsuru) Not Like '*DAHILI*')) OR (((Sheet1.AnaIsEmri) Is Null) AND ((Sheet1.ArizaTipi)='AG') AND ((Sheet1.KesintiNedeni) In ('TMŞ','TMŞA')) AND ((Sheet1.SebekeUnsuru) Not Like '*2 Çıkışı*' And (Sheet1.SebekeUnsuru) Not Like '*3 Çıkışı*' And (Sheet1.SebekeUnsuru) Not Like '*4 Çıkışı*' And (Sheet1.SebekeUnsuru) Not Like '*5 Çıkışı*' And (Sheet1.SebekeUnsuru) Not Like '6 Çıkışı' And (Sheet1.SebekeUnsuru) Not Like '*7 Çıkışı*' And (Sheet1.SebekeUnsuru) Not Like '*8 Çıkışı*' And (Sheet1.SebekeUnsuru) Not Like '*9 Çıkışı*' And (Sheet1.SebekeUnsuru) Not Like '*10 Çıkışı*' And (Sheet1.SebekeUnsuru) Not Like '*-1*' And (Sheet1.SebekeUnsuru) Not Like '*-2*' And (Sheet1.SebekeUnsuru) Not Like '*-3*' And (Sheet1.SebekeUnsuru) Not Like '*-4*' And (Sheet1.SebekeUnsuru) Not Like '*-5*' And (Sheet1.SebekeUnsuru) Not Like '*-6*' And (Sheet1.SebekeUnsuru) Not Like '*-7*' And (Sheet1.SebekeUnsuru) Not Like '*-8*' And (Sheet1.SebekeUnsuru) Not Like '*-9*' And (Sheet1.SebekeUnsuru) Not Like '*0 Çıkışı*' And (Sheet1.SebekeUnsuru) Not Like '*M01*' And (Sheet1.SebekeUnsuru) Not Like '*KORUMA*' And (Sheet1.SebekeUnsuru) Not Like '*KOUMA*' And (Sheet1.SebekeUnsuru) Not Like '*D.TR*' And (Sheet1.SebekeUnsuru) Not Like '*DAHİLİ*' And (Sheet1.SebekeUnsuru) Not Like '*DAHILI*') AND ((Sheet1.YapilanIsinAciklamasi) Not Like '*Çıkış*' And (Sheet1.YapilanIsinAciklamasi) Not Like '*Cıkıs*' And (Sheet1.YapilanIsinAciklamasi) Not Like '*çıkışı*' And (Sheet1.YapilanIsinAciklamasi) Not Like '*Çıkışı*' And (Sheet1.YapilanIsinAciklamasi) Not Like '*Çikiş*' And (Sheet1.YapilanIsinAciklamasi) Not Like '*Box*' And (Sheet1.YapilanIsinAciklamasi) Not Like '*Bax*'));