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

Mon, 03 Jul 2006 20:40:05 -0700

Makasih ya Mas Ag3ng, sekarang sudah bisa. Dan makasih juga untuk Mas Dayat :)
 
Salam,
de

ageng setia <[EMAIL PROTECTED]> wrote:
Hallo All

Boleh kasih tambahan.
jika berubah aliaskan query (Exp : SUM( Query1.BY) as BY dst...)
semoga bermanfaat

regards
Ag3ng

De ce <[EMAIL PROTECTED]> wrote:
Makasih Mas Dayat, sudah muncul recordnya tapi BY, DC & NP berubah menjadi Expr1002, Expr1003 & Expr1004 ya?
 
Salam,
de

dayat <[EMAIL PROTECTED]> wrote:
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.

Yahoo! Music Unlimited - Access over 1 million songs. Try it free.

Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min.

Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. __._,_.___

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



__,_._,___

Kirim email ke