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.
