16-09-15, 08:36 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 ='" & Val(TextBox1.Text) & "' and CustomerNo=" & Val(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 ='" & Val(TextBox1.Text) & "' and CustomerNo=" & Val(TextBox2.Text) & " Group By IDescription, UnitPrice, [Quantity], POSDate ORder By IDescription"
سبحان الله والحمدلله ولا إله إلا الله والله أكبر
اللهم اغْفِرْ لِلمؤمنين والمؤمنات والمسلمين والمسلمات الأحياء منهم والأموات
