Mas-Mas sekalian, Saya sudah rubah field JAM menjadi NUMBER dan saya run dengan query:
Select Kode, Rinician, User, Tgl, Jam, sum(jam) as hour FROM DETAIL group by Kode, Rinician,User, Tgl, Jam order by User, Tgl Tapi hasilnya tetap satu-satu ya (hasil saya attach). USER TGL KODE RINICIAN JAM DC 16/01/2006 7005008 OTHER DEVELOPMENT 1 DC 16/01/2006 7005008 OTHER DEVELOPMENT 3 DC 16/01/2006 7005008 OTHER DEVELOPMENT 4 DC 17/01/2006 8005003 MAINTENANCE 1 DC 17/01/2006 8005003 MAINTENANCE 4 Yang di harapkan hasilnya: USER TGL KODE RINICIAN JAM DC 16/01/2006 7005008 OTHER DEVELOPMENT 7 DC 17/01/2006 8005003 MAINTENANCE 5 Mohon bantuannya, terima kasih. Junias Sinaga <[EMAIL PROTECTED]> wrote: Ubah dulu field jam ke tipe data angka.Boleh integer ato float.Boleh pake cast ato convert. Select Kode, Rinician, User, Tgl, sum(cast(Jam as integer)) as hour FROM DETAIL group by Kode, Rinician, User, Tgl --- In [email protected], De ce <[EMAIL PROTECTED]> wrote: > > Mas-mas sekalian, > > Saya sudah coba dengan: > > Select Kode, Rinician, User, Tgl, sum(Jam) as hour FROM DETAIL group by Kode, Rinician, User, Tgl > > Tapi keluar error 3464 - Data type mismatch in criteria expression > > Untuk informasi saja field JAM itu bukan number tapi text apa harus saya rubah ke number ya? (maaf ini tabel warisan) > > Trims. > --hapused __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> See what's inside the new Yahoo! Groups email. http://us.click.yahoo.com/2pRQfA/bOaOAA/yQLSAA/zCsqlB/TM --------------------------------------------------------------------~-> Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED] Forum ini berkembang dengan pesat, jika anda memiliki dedikasi dan waktu, silahkan mengaplikasikan diri menjadi moderator. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indoprog-vb/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
