16-09-15, 08:25 PM
جرب
sqL = "SELECT IDescription, UnitPrice, SUM([Quantity]) as ItemQuantity, POSDate, (UnitPrice * SUM([Quantity])) As TotalAmount FROM Item as I, POS as P, POSDetail as PD WHERE I.ItemNo = PD.ItemNo AND PD.InvoiceNo=P.InvoiceNo AND StaffID =" & Format(TextBox1.Text) & "' and CustomerNo=" & textbox2.Text & " Group By IDescription, UnitPrice, [Quantity], POSDate ORder By IDescription"
sqL = "SELECT IDescription, UnitPrice, SUM([Quantity]) as ItemQuantity, POSDate, (UnitPrice * SUM([Quantity])) As TotalAmount FROM Item as I, POS as P, POSDetail as PD WHERE I.ItemNo = PD.ItemNo AND PD.InvoiceNo=P.InvoiceNo AND StaffID =" & Format(TextBox1.Text) & "' and CustomerNo=" & textbox2.Text & " Group By IDescription, UnitPrice, [Quantity], POSDate ORder By IDescription"
سبحان الله والحمدلله ولا إله إلا الله والله أكبر
اللهم اغْفِرْ لِلمؤمنين والمؤمنات والمسلمين والمسلمات الأحياء منهم والأموات
