Terimakasih banyak atas jawabanya,
Wassalm,
Ad
--- In [email protected], "M. Aksan Kurdin"
<[EMAIL PROTECTED]> wrote:
>
> 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" <ms.ac07@> 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
> >
>
