Re: [Programmer-VB] Tanya query lagi ya...

[dayat]

dari query ini field BY, DC, NP muncul ga? Tipe data field Jam integer
kan? aku pake postgresql dan bisa jalanin query itu, Jet mungkin lain
ya. Klo begitu coba query dibawah ini aja, klo sukses or gagal bilang
ya.

SELECT Query1.Kode, Query1.Rincian, SUM(
Query1.BY), SUM(Query1.DC), SUM(
Query1.NP) FROM
(SELECT Kode, Rincian, IIF(User='BY',Jam,0)AS BY, IIF(User='DC',Jam,0)AS DC, IIF(User='NP',Jam,0)AS NP
FROM Table1)Query1
GROUP BY Query1.Kode, 
Query1.Rincian;On 7/4/06, De ce <[EMAIL PROTECTED]
> wrote:


Pagi Mas, saya sudah coba query-nya tapi yang tampil hanya record dari Kode dan Rincian saja,      Kode        
Rincian                     User  0100025    Administration             0100026   
Mentoring                   0100030   
Marketing                       padahal yang diharapkan adalah:     Kode        
Rincian                    
BY         
DC           NP  0100025   
Administration          
16          
13            2  0100026   
Mentoring                 
3            
2            
0  0100030   
Marketing                  0            
0             15  Tks.     de  dayat <
[EMAIL PROTECTED]> wrote:      sori lupa sama field rincian pada klausa GROUP BY
SELECT Kode, Rincian, SUM(BY), SUM(DC), SUM(NP) FROM(SELECT Kode, Rincian, IIF(User='BY',Jam,0)AS BY, IIF(User='DC',Jam,0)AS DC, IIF(User='NP',Jam,0)AS NP
FROM Table1)Query1
GROUP BY Kode, Rincian;  klo
banyak user dan ga mau memasukkan satu2, pake crosstab query. Coba cari
di helpnya microsoft access. pake wizard atau baca sql-nya, bila udah
jalan dan menghasilkan yang diinginkan copy aja sql-nya ke vb.

  








__._,_.___





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.



  






__,_._,___