برجاء شرح جملة Sql فى احدى امثلة الاستاذة العظيمة ام عهود
SELECT NewTable.ID, NewTable.CustomerID, NewTable.Date, NewTable.NUM, NewTable.[iN], NewTable.OUT, (select(sum([iN])-sum([OUT])) from [RASEEDB] where newtable.[iD]>=[iD] and NewTable.[CustomerID]= [CustomerID] ) AS TRASEED
FROM RASEEDB AS NewTable
WHERE (((NewTable.CustomerID)=[forms]![bank]![CusName]))
ORDER BY NewTable.ID, NewTable.Date;
مرفق الملف