[atefkhalf2004]

كود :

command.CommandText = "SELECT a.itcod  , a.invsun, a.purqu ,  a.invqu , (select sum(-invqu+purqu) from adraseed   as b  where     b.itcod=  a.itcod  ) AS BALANCE   FROM adraseed AS a  where a.itcod=  " & ComboBox1.SelectedValue & "  "
       command.CommandText = "SELECT a.itcod  , a.invsun, a.purqu  , a.invqu  , (select sum(-invqu+purqu) from adraseed   as b   where   b.atefinv <= a.atefinv and  b.itcod=  a.itcod  ) AS BALANCE, a.invdate, a.atefinv FROM adraseed AS a  where a.itcod=  " & ComboBox1.SelectedValue & "   ORDER BY a.invdate "
      

الكودين
الاول يعرض الرصيد  النهائي
والثاني لا يعرض الرصيد

---

في سكول  والفيجوال
قاعدة سكول  وفيجوال

شخص  يحل لي الموضوع