Sorry juga , mestinya pake Max, bukan Last
Sehingga query yang benar adalah: select a.NIP, a.Tanggal, a.Status from tblDataHistory as a INNER JOIN ( SELECT tblDataHistory.NIP, MAX(tblDataHistory.Tanggal) AS Tanggal FROM tblDataHistory GROUP BY tblDataHistory.NIP ) as b ON (a.NIP=b.NIP) and (a.Tanggal=b.Tanggal) Terimakasih, MBA From: [email protected] [mailto:[email protected]] On Behalf Of Budi.P Sent: Tuesday, September 08, 2009 12:35 To: [email protected] Subject: Bls: [belajar-access] bikin sql script maaf ada kesalahan, hasil yg diinginkan sbb: 1000001 13/08/2009 Active 1000002 26/06/2009 Active thks _____ Dari: Budi.P <[email protected]> Kepada: Belajar Access <[email protected]> Terkirim: Selasa, 8 September, 2009 12:02:40 Judul: [belajar-access] bikin sql script siang teman2, saya punya data history sbb: NIP Tanggal Status 1000001 16/01/2007 Active 1000001 25/06/2009 Non Active 1000001 13/08/2009 Active 1000002 01/01/2007 Active 1000002 04/06/2009 Non Active 1000002 25/06/2009 Non Active 1000002 26/06/2009 Active gimana caranya buat query (sql script) sehingga data yg dihasilkan sbb: 1000001 13/08/2009 Active 1495101 26/06/2009 Active thks atas masukannya, salam, Budi _____ Menambah banyak teman sangatlah mudah dan cepat. <http://sg.rd.yahoo.com/id/messenger/trueswitch/mailtagline/*http:/id.messenger.yahoo.com/invite/> Undang teman dari Hotmail, Gmail ke Yahoo! Messenger sekarang! _____ Lebih aman saat online. Upgrade <http://us.lrd.yahoo.com/_ylc=X3oDMTFndmQxc2JlBHRtX2RtZWNoA1RleHQgTGluawR0bV9sbmsDVTExMDM0NjkEdG1fbmV0A1lhaG9vIQ--/SIG=11kadq57p/**http%3A/downloads.yahoo.com/id/internetexplorer/> ke Internet Explorer 8 baru dan lebih cepat yang dioptimalkan untuk Yahoo! agar Anda merasa lebih aman. Gratis. Dapatkan <http://us.lrd.yahoo.com/_ylc=X3oDMTFndmQxc2JlBHRtX2RtZWNoA1RleHQgTGluawR0bV9sbmsDVTExMDM0NjkEdG1fbmV0A1lhaG9vIQ--/SIG=11kadq57p/**http%3A/downloads.yahoo.com/id/internetexplorer/> IE8 di sini! No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.409 / Virus Database: 270.13.82/2351 - Release Date: 09/07/09 06:40:00
