pada dasarnya semua bisa dilakukan dengan access, pertama buat table1 sbb;
| DetailID | trxID | custID | DEBET | KREDIT |
|---|---|---|---|---|
| 1 | 1234 | 1 | 5 | 1 |
| 2 | 1234 | 2 | 4 | 5 |
| 3 | 1234 | 3 | 3 | 1 |
| 4 | 1235 | 1 | 2 | 2 |
| 5 | 1235 | 3 | 1 | 3 |
| 6 | 1235 | 5 | 0 | 1 |
| 7 | 1235 | 2 | 3 | 2 |
kemudian buat query sbb;
SELECT
A.DetailID, A.trxID, A.custID, A.DEBET, A.KREDIT,
IIf([DEBET]-[kredit]>=0,[DEBET]-[kredit],[debet]-[KREDIT]) AS MUTASI, Format(DSum("mutasi","query2","detailID <=" & [DetailID]),"Currency") AS SaldoFROM TABLE1 AS A
ORDER BY A.DetailID;
ORDER BY A.DetailID;
| DetailID | trxID | custID | DEBET | KREDIT | MUTASI | Saldo |
|---|---|---|---|---|---|---|
| 1 | 1234 | 1 | 5 | 1 | 4 | Rp.4.00 |
| 2 | 1234 | 2 | 4 | 5 | -1 | Rp.3.00 |
| 3 | 1234 | 3 | 3 | 1 | 2 | Rp.5.00 |
| 4 | 1235 | 1 | 2 | 2 | 0 | Rp.5.00 |
| 5 | 1235 | 3 | 1 | 3 | -2 | Rp.3.00 |
| 6 | 1235 | 5 | 0 | 1 | -1 | Rp.2.00 |
| 7 | 1235 | 2 | 3 | 2 | 1 | Rp.3.00 |
