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