Sama sama mbak Dian Novian. Maaf, saya kira laki-laki. :) Salam Hangat dan Jabat Erat, MBA
_____ From: [email protected] [mailto:[email protected]] On Behalf Of dinov parlente Sent: Thursday, 25 March, 2010 16:56 To: [email protected] Subject: Re: [belajar-access] Reporting data tabel.. Betul Pak MBA.. Terima kasih Pak.. saya coba dulu.. 2010/3/24 MBA <murid.belajaraccess <mailto:[email protected]> @gmail.com> Bapak, apakah seperti ini ? TRANSFORM First(Periode.Nilai) AS NILAI SELECT Periode.Nama FROM Periode GROUP BY Periode.Nama PIVOT Periode.Periode; Salam hangat dan jabat erat, MBA _____ From: belajar-access@ <mailto:[email protected]> yahoogroups.com [mailto:belajar-access@ <mailto:[email protected]> yahoogroups.com] On Behalf Of dinov parlente Sent: Wednesday, 24 March, 2010 18:03 To: belajar-access@ <mailto:[email protected]> yahoogroups.com Subject: [belajar-access] Reporting data tabel.. Dear All, Saya punya tabel seperti dibawah ini : Tabel : Periode Nama Periode Nilai A 012010 1 A 022010 2 A 032010 3 B 102010 5 B 022010 6 C 022010 7 Saya pengen menampilkan di reportnya seperti dibawah ini : O12010 022010 032010 A 1 2 3 B 5 6 Null C Null 7 Null Mohon pencerahannya.. utk sintak query-nya ? Terima kasih.. Salam, Dian No virus found in this incoming message. Checked by AVG - www.avg.com <http://www.avg.com/> Version: 9.0.791 / Virus Database: 271.1.1/2766 - Release Date: 03/24/10 02:33:00 No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.791 / Virus Database: 271.1.1/2768 - Release Date: 03/25/10 02:33:00
<<GGI-000021 (PSDM_EDY - edy).jpg>>
