SELECT Sayfa1.[No], Sayfa1.[Sıra no], Sayfa1.[Firma adı], IIf([SSHYB1]>=Forms!Form1!Metin0 And [sshyb1]<=Forms!Form1!Metin2,[sshyb1],"") AS S1, IIf([SSHYB2]>=Forms!Form1!Metin0 And [sshyb2]<=Forms!Form1!Metin2,[sshyb2],"") AS S2, IIf([gb1]>=Forms!Form1!Metin0 And [gb1]<=Forms!Form1!Metin2,[gb1],"") AS G1, IIf([gb2]>=Forms!Form1!Metin0 And [gb2]<=Forms!Form1!Metin2,[gb2],"") AS G2, IIf([gb3]>=Forms!Form1!Metin0 And [gb3]<=Forms!Form1!Metin2,[gb3],"") AS G3, IIf([gb4]>=Forms!Form1!Metin0 And [gb4]<=Forms!Form1!Metin2,[gb4],"") AS G4, IIf([gb5]>=Forms!Form1!Metin0 And [gb5]<=Forms!Form1!Metin2,[gb5],"") AS G5
FROM Sayfa1
WHERE (((IIf([SSHYB1]>=[Forms]![Form1]![Metin0] And [sshyb1]<=[Forms]![Form1]![Metin2],[sshyb1],"")) Between ([Forms]![Form1]![Metin0]) And ([Forms]![Form1]![Metin2])) AND (([Forms]![Form1]![n1])=-1)) OR (((IIf([SSHYB2]>=[Forms]![Form1]![Metin0] And [sshyb2]<=[Forms]![Form1]![Metin2],[sshyb2],"")) Between ([Forms]![Form1]![Metin0]) And ([Forms]![Form1]![Metin2])) AND (([Forms]![Form1]![n2])=-1)) OR (((IIf([gb1]>=[Forms]![Form1]![Metin0] And [gb1]<=[Forms]![Form1]![Metin2],[gb1],"")) Between ([Forms]![Form1]![Metin0]) And ([Forms]![Form1]![Metin2])) AND (([Forms]![Form1]![n3])=-1)) OR (((IIf([gb2]>=[Forms]![Form1]![Metin0] And [gb2]<=[Forms]![Form1]![Metin2],[gb2],"")) Between ([Forms]![Form1]![Metin0]) And ([Forms]![Form1]![Metin2])) AND (([Forms]![Form1]![n4])=-1)) OR (((IIf([gb3]>=[Forms]![Form1]![Metin0] And [gb3]<=[Forms]![Form1]![Metin2],[gb3],"")) Between ([Forms]![Form1]![Metin0]) And ([Forms]![Form1]![Metin2])) AND (([Forms]![Form1]![n5])=-1)) OR (((IIf([gb4]>=[Forms]![Form1]![Metin0] And [gb4]<=[Forms]![Form1]![Metin2],[gb4],"")) Between ([Forms]![Form1]![Metin0]) And ([Forms]![Form1]![Metin2])) AND (([Forms]![Form1]![n6])=-1)) OR (((IIf([gb5]>=[Forms]![Form1]![Metin0] And [gb5]<=[Forms]![Form1]![Metin2],[gb5],"")) Between ([Forms]![Form1]![Metin0]) And ([Forms]![Form1]![Metin2])) AND (([Forms]![Form1]![n7])=-1));
Renklendirme işlemi biraz zor bir iş, alternatif bir çözüm olarak renklendirme yerine Sorgu1'in Sql satırlarını aşağıdakiyle değiştirip deneyiniz.
Saygılar, iyi çalışmalar.
*********
Kod, formül vs bilmek önemlidir ama mantığını yürütebilmek, nerede ve nasıl kullanılacağını bilmek daha önemlidir.
*********
Kod, formül vs bilmek önemlidir ama mantığını yürütebilmek, nerede ve nasıl kullanılacağını bilmek daha önemlidir.