Changing the position of values with respect to running total

[haider378]

please help I want to move credit entries according to the running total balance there are two tables first showing the actual position of credit entries and my requirement is second table showing the adjustment of credit entry as according to balance Table 1 Decription Debit Credit Balance Sales against Invoice #1142 177,982 177,982 Sales against Invoice #1187 147,191 325,173 Sales against Invoice #1219 74,391 399,564 Sales against Invoice #1232 83,116 482,680 Sales against Invoice #1259 165,810 648,490 Sales against Invoice #1260 151,811 800,301 Sales against Invoice #1286 161,667 961,968 Sales against Invoice #1390 33,743 995,711 Sales against Invoice #1402 152,624 1,148,335 Sales against Invoice #1527 64,109 1,212,444 Sales against Invoice #1578 141,521 1,353,965 Sales against Invoice #1587 142,100 1,496,065 Sales against Invoice #1607 82,352 1,578,417 BR # 887 400,000 1,178,417 Sales against Invoice #1630 77,255 1,255,672 BR # 896 500,000 755,672 BR # 927 400,000 355,672 Sales against Invoice #1705 185,646 541,318 Sales against Invoice #1745 126,650 667,968 Sales against Invoice #1778 102,642 770,610 Sales against Invoice #1808 75,614 846,224 Sales against Invoice #1818 175,880 1,022,104 Sales against Invoice #1837 60,320 1,082,424 BR # 1021 142,100 940,324 <colgroup></colgroup><tbody> </tbody> Table 2 Chq Amount Running Balance 177,982 325,173 399,564 400,000 82,680 248,490 400,301 500,000 61,968 95,711 248,335 312,444 400,000 53,965 142,100 53,965 136,317 136,317 213,572 213,572 213,572 399,218 500,000 25,868 128,510 204,124 380,004 440,324 440,324 <colgroup></colgroup><tbody> </tbody> <colgroup></colgroup><tbody> </tbody>

<colgroup></colgroup><tbody>
</tbody>