hi guys, maya coba kutak-katik kode dari mas CaCa di querynya Access tapi kalo memakai kode spt dibawah ini
UPDATE Acc3 INNER JOIN JurnalDetil ON Acc3.kode3 = JurnalDetil.kode3 SET Acc3.dbpos = JurnalDetil.debet WHERE JurnalDetil.db=(SELECT SUM(db) AS debet FROM JurnalDetil); menghasilkan o(nol) row effected. artinya tidak ada record yg ter update di tabel Acc3. kenapa ya? mungkin mas2 ada yg bisa membantu dengan kode diatas tsb. maya menggunakan VB6 SP6, database Access XP tapi skrng diganti Access 2003 SP1. makasih atas bantuanya. regards maya __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Something is new at Yahoo! Groups. Check out the enhanced email design. http://us.click.yahoo.com/SISQkA/gOaOAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> Wahana Programmer Groups Links <*> Untuk mengunjungi sponsor milis ini, klik link berikut: http://wahanaprogrammer.net <*> Untuk menghubungi owner milis ini, kirim email ke: [EMAIL PROTECTED] <*> Konsultasi pemrogramman bisa chat disini: Yahoo! Messenger: wahanaprogrammer Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Programmer-VB/ <*> 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/
