Dua langkah: Bikin query : SELECT Untitled.nama, Untitled.date, Untitled.Timein, "TimeIn" AS Type FROM Untitled; UNION ALL SELECT Untitled.nama, Untitled.date, Untitled.TimeOut, "TimeOut" AS Type FROM Untitled;
Simpan query sebagai Query1 misalnya, lalu query lagi dengan crosstab: TRANSFORM First(Query1.Timein) AS FirstOfTimein SELECT Query1.nama, Query1.Type FROM Query1 GROUP BY Query1.nama, Query1.Type PIVOT Query1.date; Hasilnya: nama Type 8/1/2007 8/2/2007 8/3/2007 A TimeIn 8:09:00 AM 8:00:00 AM 8:00:00 AM A TimeOut 6:09:00 PM 5:09:00 PM 2:00:00 PM B TimeIn 8:09:00 AM 8:09:00 AM 8:09:00 AM B TimeOut 5:00:00 PM 6:09:00 PM 7:09:00 PM Aksan Kurdin --- In [email protected], "ms.ac07" <[EMAIL PROTECTED]> wrote: > > Dear All, > > Saya mempunyai table: > > Tbl-A > id nama date Timein TimeOut > 1 A 08/01/07 08:09 18:09 > 2 A 08/02/07 08:00 17:09 > 3 A 08/03/07 08:00 14:00 > 4 B 08/01/07 08:09 17:00 > 5 B 08/02/07 08:09 18:09 > 6 B 08/03/07 08:09 19:09 > > sy ingin tampil di report nya( Tanggal Horizontal Kesamping): > > Nama: A > 08/01/07 08/02/07 08/02/07 > TimeIn 08:09 08:00 08:00 > TimeOut 18:09 17:09 14:00 > > Nama: B > 08/01/07 08/02/07 08/03/07 > TimeIn 08:09 08:00 08:09 > TimeOut 18:09 17:09 19:09 > > > Mohon Pencerahan nya, saya sudah pake crosstab tapi blom berhasil. > > Terimakasih, > Ad >
