It's possible to do with a query but not very efficient. A subquery has to process all the records before current date for each date
SELECT Date, (SELECT SUM(mt2.Balance) FROM mytable mt2
WHERE mt2.date < mt.date ) AS RunningBalance
FROM mytable mt
GROUP BY Date
ORDER BY Date
>
>How to calculate a accumulative balance in SP select statement to create running balance for an item. The data will be as following columns:-
>
>Date inQty Outqty ``Balance
>---------------------------------
>
>Best Regards
--sb--