09-06-24, 02:34 AM
السلام عليكم ورحمة الله وبركاته
Where
بتكون قبل
GROUP BY
التصحيح :
Where
بتكون قبل
GROUP BY
التصحيح :
كود :
Report9.DataControl1.Source = "SELECT TBL_employees.ID, TBL_employees.NameTeacher, Sum(TBL_Daily.L_Req) AS SumonL_Req, Sum(TBL_Daily.Reson1) AS SumonReson1, Sum(TBL_Daily.RnsQ1) AS SumonRnsQ1, " _
& " Sum(TBL_Daily.Reson2) AS SumonReson2, Sum(TBL_Daily.RnsQ2) AS SumonRnsQ2, Sum(TBL_Daily.L_Done) AS SumonL_Done, TBL_employees.Bank, TBL_employees.BBank, " _
& " TBL_employees.Account, TBL_Daily.L_Date, TBL_employees.IDnumber, Month([L_Date]) AS XMonth " _
& " FROM (TBL_Daily INNER JOIN TBL_employees ON TBL_Daily.ID=TBL_employees.ID) INNER JOIN TBL_Month ON TBL_employees.ID=TBL_Month.MONo " _
& " Where Month([L_Date]) = '" & Trim(CombMonth.ListIndex) + 1 & "' " _
& " GROUP BY TBL_employees.ID, TBL_employees.NameTeacher, TBL_employees.Bank, TBL_employees.BBank, TBL_employees.Account, TBL_Daily.L_Date, TBL_employees.IDnumber, Month([L_Date]) " _
& " ORDER BY TBL_employees.ID ;"قال صلى الله عليه وسلم:
«كلمتان خفيفتان على اللسان
ثقيلتان في الميزان،حبيبتان إلى الرحمن:
سبحان الله وبحمده، سبحان الله العظيم».
