select a.NIP, a.Tanggal, a.Status from tblDataHistory as a INNER JOIN
( SELECT tblDataHistory.NIP, Last(tblDataHistory.Tanggal) AS Tanggal FROM tblDataHistory GROUP BY tblDataHistory.NIP ) as b ON (a.NIP=b.NIP) and (a.Tanggal=b.Tanggal) Query4 NIP Tanggal Status 1000001 8/13/2009 Active 1000002 6/26/2009 Active Meskipun ada yang aneh. 1000001 13/08/2009 Active 1495101 26/06/2009 Active Angka 1495101 itu dapat dari mana yaa?? Salam, MBA From: [email protected] [mailto:[email protected]] On Behalf Of Budi.P Sent: Tuesday, September 08, 2009 12:03 To: Belajar Access Subject: [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 <http://sg.rd.yahoo.com/id/messenger/trueswitch/mailtagline/*http:/id.messenger.yahoo.com/invite/> banyak teman sangatlah mudah dan cepat. Undang teman dari Hotmail, Gmail ke Yahoo! Messenger sekarang! 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
<<image001.jpg>>
