Dear all,
saya mohon pencerahan nih. Saya mempunyai data seperti berikut:
TABEL PINJAMAN
TGL KREDIT KODE PINJAMAN JK WAKTU BUNGA
01/07/2007 A1 24.000.000 24 1%
03/12/2007 A2 15.000.000 30 1%
31/12/2007 A3 6.000.000 24 1%
TABEL ANGSURAN
TGL ANGSURAN KODE POKOK PINJAMAN BUNGA ANGSURAN
01/08/2007 A1 1.000.000 240.000
1.240.000
01/09/2007 A1 1.000.000 240.000
1.240.000
01/10/2007 A1 1.000.000 240.000
1.240.000
01/11/2007 A1 1.000.000 240.000
1.240.000
01/12/2007 A1 1.000.000 240.000
1.240.000
02/01/2008 A1 1.000.000 240.000
1.240.000
03/01/2008 A2 500.000 150.000
650.000
21/01/2008 A3 250.000 60.000
310.000
QUERY SISA PINJAMAN
TGL KREDIT KODE PINJAMAN TOTAL POKOK PINJAMAN SISA PINJAMAN
01/07/2007 A1 24.000.000 6.000.000
18.000.000
03/12/2007 A2 15.000.000 500.000
14.500.000
31/12/2007 A3 6.000.000 250.000
5.750.000
Bagaimana cara menjumlahkan TOTAL POKOK PINJAMAN untuk menghasilkan data
seperti pada QUERY SISA PINJAMAN.
Selama ini saya mempergunakan Crosstab Query, tapi saya kesulitan untuk
merelasikan dengan TABEL PINJAMAN.
Thanks B4
Regards
Wuryantadi
___________________________________________________________
Inbox full of spam? Get leading spam protection and 1GB storage with All New
Yahoo! Mail. http://uk.docs.yahoo.com/nowyoucan.html
SPAM IS PROHIBITED
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/belajar-access/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/belajar-access/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
