ooooooooooooooooooo....... ok. kalo gitu ngerti......... makacih masssssssssssssssssssssssssssssssssss
2008/6/24, Ivan Leonardo <[EMAIL PROTECTED]>: > 4. utk liaht saldo hutang group tbl-bayar by nofaktur misalnya sum nilai > bayar, nah lalu dicompare deh sama nilai yg ada di tbl-hutang > ** > A. buat QRY-BYR, tbl-bayar kan 1 nofaktur bisa beberapa kali > bayar(kredit) nah krn itu query perlu di group by nofaktur dan nilai > bayarnya sum kan jadinya ketemu total yg sudah dibayar utk masing2 > nofaktur yg ada di tbl-bayar > B. buat query baru yg isinya tbl-hutang dan qry-byr link by nofaktur, > tinggal dibanding deh nilaihutang-nilaibayar, if = 0 berarti sudah > lunas, if >0 berarti belum lunas dan itu nilai saldonya. > > query B ini bisa dipakai utk report/form info saldo hutang > > mudah2 an ngerti deh, udah mentok nih jelasinnya hehehe > > > --------------------------------------------------------------------------- > This message contains confidential information and is intended only for the > individual named. If you are not the named addressee you should not > disseminate, distribute or copy this e-mail. Please notify the sender > immediately by e-mail if you have received this e-mail by mistake and delete > this e-mail from your system. E-mail transmission cannot be guaranteed to be > secure or error-free as information could be intercepted, corrupted, lost, > destroyed, arrive late or incomplete, or contain viruses. The sender > therefore does not accept liability for any errors or omissions in the > contents of this message, which arise as a result of e-mail transmission. If > verification is required please request a hard-copy version. > >
