select no_Pegawai, sum( Jam_Kerja )
  from Tabel
  where no_Pegawai = '001' and tanggal between '2005-12-01' and '2005-12-21'
  
  Abdul Tahir <[EMAIL PROTECTED]> wrote:          Rekan-Rekan Milis yg baik 
hati...
  Saya Punya Tabel Sbb
  
No_Pegawai             Jam_Kerja             Tanggal
  001                   2                   01/09/2005
  002                   1                   02/02/2006
  001                   2                   01/12/2005
  
  
  Trus saya mau Menampilkan Total Jam  Kerja untuk 
  No_Pegawai 001 Pada Periode 01/12/2005 s/d 21/12/2005 Saja.
  
  Gimana ya Codenya?
  Terima Kasih
  Tahir
  
  
  
  
            

    Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED]
  
  Ikuti juga forum diskusi VB.net dengan 
  mengirim email kosong ke [EMAIL PROTECTED]
    

                      

          SPONSORED LINKS    
                                                        Computer internet 
security                                          Computer internet business    
                                      Computer internet access                  
                                                        Computer internet 
privacy securities                                          Computer internet 
help                                                             
        
---------------------------------
    YAHOO! GROUPS LINKS  
  
      
    Visit your group "indoprog-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.  
  
      
---------------------------------
  
  
          


                        
---------------------------------
 Yahoo! Autos. Looking for a sweet ride? Get pricing, reviews, & more on new 
and used cars.

[Non-text portions of this message have been removed]



Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED]

Ikuti juga forum diskusi VB.net dengan 
mengirim email kosong ke [EMAIL PROTECTED]
 
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/
 


Kirim email ke