coba gunakan fungsi data convertion kayak CAST atau CONVERT kalau di sql server, atau TO_NUMBER kalau di oracle buat ngubah data textnya ke number.
sincera
[wwn]
On 6/15/06, 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.
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.
