Silakan dicoba pak, tinggal menambahkan sedikit query. Kemudian Record source
form di ambil dari Query ini.
SELECT NamaTable.ID, NamaTable.Keterangan, NamaTable.Masuk, NamaTable.Keluar,
IIf(([Masuk])>0,[Masuk],-[Keluar]) AS Amount,
Format(CCur(DSum("Amount","QRYNamaTabel","[id]<=" & [id])),"Standard") AS Saldo
FROM NamaTable
ORDER BY NamaTable.ID;
Salam sareng sameton sami ring Bali.
Matur suksema,
Sumiyanto
________________________________
From: Hasan Salman <[email protected]>
To: [email protected]
Sent: Wed, June 23, 2010 11:01:10 AM
Subject: [belajar-access] Runningsum Dalam Form
Saya mengalami kesulitan ketika mau
membuat runningsum dalam form.
contoh formnya begini:
------------ --------- --------- --------- --------- --------- ---------
--------- --------- --------- -
| No. | Keterangan | Masuk | Keluar |
Saldo |
------------ --------- --------- --------- --------- --------- ---------
--------- --------- --------- -
| 1. | Penjualan |1.000.000|
|1.000.000 |
| 2. | Bayar Rekening Listrik | | 250.000 |
750.000 |
| 3. | Bayar Rekening Air | | 100.000 |
650.000 |
============ ========= ========= ========= ========= ========= ==
Yang saya tanyakan adalah, bagaimana agar Field Saldo itu bisa
berlanjut terus (Runningsum), ada yang bisa membantu?
Salman Hasan
Denpasar = Bali
