ya iyalah bro jam itu ga bisa langsung di sum begitu aja, ya nanti jadinya
ya ngaco,
nieh bro semoga membantu
" SELECT TOP 40 tbltransaksi.Meja, Sum(hour(tbltransaksi.total)) as hour,
Sum(minute(tbltransaksi.total)) as minute, Sum(tbltransaksi.jumlah) AS
Jumlah From tbltransaksi WHERE
transaksi.Meja <> '0' "
On 10/6/07, adhe_vendy <[EMAIL PROTECTED]> wrote:
>
>
> gimana cara jumlahkan jam / waktu di database misal acces ??
>
> contoh kasus,
>
> gw lg bikin program biling untuk biliard.
>
> disitu ada 40 meja.
>
> terus gw diminta membuat laporan untuk meja yang paling sering
> dipakai berdasarkan lamanya pemakaian.
>
> gw pke script Sql :
> " SELECT TOP 40 tbltransaksi.Meja, Sum(tbltransaksi.total) AS
> totaljam, Sum(tbltransaksi.jumlah) AS Jumlah From tbltransaksi WHERE
> transaksi.Meja <> '0' "
>
> ket:
> gw pnya tbel namanya tbltransaksi
> fieldnya :
> meja, >> nomor meja
> total >> lamanya pemakaian format(hh:mm:ss)
> Jumlah>> jumlah biaya pemakaina format ("###,###,###")
>
> udah gw coba pake script diatas, ternyata jumlah jamnya ngaco...
> yang ter jumlah cuma jamnya aja, menitnya ga kejumlah....
>
> ada yang tau caranya????
> Help me....
>
> Thanx bwt yang bantu...
>
>
>
--
--~--~---------~--~----~------------~-------~--~----~
LAB UNDERGRON...!!!
we here because we want to...!!
-~----------~----~----~----~------~----~------~--~---
[Non-text portions of this message have been removed]
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> 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/
