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.
tahar dn <[EMAIL PROTECTED]> wrote:
Kayaknya nya begini sintak sqlnya :"select code,act,user,date,sum(hour) hour from ..... group by code,act,user,datemudah-mudahan bisa
De ce <[EMAIL PROTECTED]> wrote:Rekan mau tanya nih,
Code Act User Date Hour
0001 Administrasi Budi 14/06/2006 1
0002 Marketing Budi 14/06/2006 4
0003 Meeting Budi 14/06/2006 1
0001 Administrasi Budi 14/06/2006 1
Data di atas kode 0001 terdapat 2 transaksi dan yang ingin saya tanyakan bagaimana command untuk bisa search sekalian filter dengan tampilan sbb:
Code Act User Date Hour
0001 Administrasi Budi 14/06/2006 2
0002 Marketing Budi 14/06/2006 4
0003 Meeting Budi 14/06/2006 1
Kalau saya menggunakan query select distinct code ... maka penjumlahan jamnya tidak ada. Mohon bantuannya.
Terima kasih
ME
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
__._,_.___
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
SPONSORED LINKS
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
