Me.Liste1.RowSource = "SELECT HATA_LISTESI_TOP_KG.OPERATOR, Sum(HATA_LISTESI_TOP_KG.TOP_KG) AS ToplaTOP_KG FROM HATA_LISTESI_TOP_KG WHERE (HATA_LISTESI_TOP_KG.TARIH" & ILKTAR & ") And (HATA_LISTESI_TOP_KG.TARIH" & SONTAR & ") GROUP BY HATA_LISTESI_TOP_KG.OPERATOR ORDER BY Sum(HATA_LISTESI_TOP_KG.TOP_KG) DESC"
kodu
Alttaki Kodla değiştirin.
Me.Liste1.RowSource = "SELECT HATA_LISTESI_TOP_KG.OPERATOR, format(Sum(HATA_LISTESI_TOP_KG.TOP_KG),0) AS ToplaTOP_KG FROM HATA_LISTESI_TOP_KG WHERE (HATA_LISTESI_TOP_KG.TARIH" & ILKTAR & ") And (HATA_LISTESI_TOP_KG.TARIH" & SONTAR & ") GROUP BY HATA_LISTESI_TOP_KG.OPERATOR ORDER BY Sum(HATA_LISTESI_TOP_KG.TOP_KG) DESC"