running balance problam ????????

[deepakghakhar]

Date Party + - balance1 Running Balance
1.1.15 A 100 100 100
1.1.15 b 100 100 100
2.1.15 a 50 50 50
BALANCE LIKE THIS BUT I FINE LIKE BELOW TABLE
Date Party + - balance1 Running Balance
1.1.15 A 100 100 100
1.1.15 b 100 100 100
2.1.15 a 50 50 50

IF I USE MAKE TWO QUERY IN FIRST QUERY
DATEALIAS PARTY + -
RunningSum: CCur(DSum("[Balance]","[DDD0]","[Date]<=#" & Format([Date],"dd/mm/yyyy") & "#"))
Then Problam is Balane istotal of that date I want balance only previous entry and second same report party wise
Date Party + - balance1 Running Balance
1.1.15 A 100 100 200
1.1.15 b 100 100 200
2.1.15 a 50 50 150
Please Healp Me