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 ------------------------ Yahoo! Groups Sponsor --------------------~--> Great things are happening at Yahoo! Groups. See the new email design. http://us.click.yahoo.com/TISQkA/hOaOAA/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/
