Terima kasih Mas Sumiyanto, jasa anda nggak akan saya lupakan. Lho kok bisa bahasa Bali?
Matur nuwun Salman Hasan. ________________________________ Dari: Sumiyanto - <[email protected]> Kepada: [email protected] Terkirim: Rab, 23 Juni, 2010 14:18:16 Judul: Re: [belajar-access] Runningsum Dalam Form [1 Attachment] [Attachment(s) from Sumiyanto - included below] Silakan dicoba pak, tinggal menambahkan sedikit query. Kemudian Record source form di ambil dari Query ini. SELECT NamaTable.ID, NamaTable.Keteranga n, 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 <salmankomputer@ yahoo.com> To: belajar-access@ yahoogroups. com 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
