Select Date, Code, Sum(Amount) as Total, >> (SELECT Sum(ord2.Amount) From Orders ord2 >> Where fk_Customer = 1 >> And Date Between '20020101' and '20021231' >> And ord2.date() <= orders.date() >> And ord2.code = orders.code) AS RunTotal >> From Orders >> Where fk_Customer = 1 And Date Between '20020101' and '20021231' >> Group by Code, Date >> Order by Code, DateI tested above query and it produces result you want.