#19
#20
sorgu1 = "SELECT SatisTarih, SatisFiyat" _
& " FROM Query1" _
& " WHERE SatisFiyat In (SELECT top " & gunsayisi1 & " Sum(tr.SatisFiyat) AS ToplaSatisFiyatb" _
& " FROM Tbl_Satis_Dagilim AS tr Where month(Query1.SatisTarih)=month(tr.SatisTarih)" _
& " GROUP BY tr.SatisTarih ORDER BY Sum(tr.SatisFiyat) DESC)" _
& " ORDER BY Query1.SatisTarih, Query1.SatisFiyat DESC"sorgu = "SELECT SatisTarih, SatisFiyat" _
& " FROM Query1 AS trz" _
& " WHERE (select count(*) from" _
& " (SELECT SatisTarih, Sum(SatisFiyat) AS tSatisFiyat FROM Query1" _
& " GROUP BY SatisTarih ORDER BY Sum(SatisFiyat) DESC)" _
& " where month(SatisTarih)=month(trz.SatisTarih)" _
& " and tSatisFiyat>=trz.SatisFiyat)<=Int([Forms]![ReportForm]![CDateCount])"
database1.rar
(Dosya Boyutu: 126 KB | İndirme Sayısı: 9)
#21
#22
#23
