Dim SQL As String
SQL = "SELECT Query1.Kode, Query1.Rinician, SUM(Query1.AE) as AE, SUM(Query1.AN) as AN, SUM(Query1.AW) as AW, SUM(Query1.DC) as DC, SUM(Query1.DD) as DD , SUM(Query1.DL) as DL, SUM(Query1.DN) as DN, SUM(Query1.EF) as EF, SUM(Query1.ES) as ES, SUM(Query1.FAS) as FAS, SUM(Query1.FS) as FS, SUM(Query1.HT) as HT, SUM(Query1.IIS) as IIS, SUM(Query1.IR) as IR, SUM(Query1.KA) as KA, SUM(Query1.KI) as KI, SUM(Query1.KS) as KS, SUM(Query1.MI) as MI, SUM(Query1.MJ) as MJ, SUM(Query1.MS) as MS, SUM(Query1.NN) as NN "
SQL = SQL & "FROM (SELECT Kode, Rinician, IIF(User='AE',Jam,0)AS AE, IIF(User='AN',Jam,0)AS AN, IIF(User='AW',Jam,0)AS AW, IIF(User='DC',Jam,0)AS DC, IIF(User='DD',Jam,0) AS DD, IIF(User='DL',Jam,0) as DL, IIF(User='DN',Jam,0) as DN, IIF(User='EF',Jam,0) as EF, IIF(User='ES',Jam,0) as ES, IIF(User='FAS',Jam,0) as FAS, IIF(User='FS',Jam,0) as FS, IIF(User='HT',Jam,0) as HT, IIF(User='IIS',Jam,0) as IIS, IIF(User='IR',Jam,0) as IR, IIF(User='KA',jam,0) as KA, IIF(User='KI',Jam,0) as KI, IIF(User='KS',Jam,0) as KS, IIF(User='MI',Jam,0) as MI, IIF(User='MJ',Jam,0) as MJ, IIF(User='MS',Jam,0) as MS, IIF(User='NN',Jam,0) as NN FROM detail)Query1 GROUP BY Query1.Kode, Query1.Rinician"
...dan seterusnya...
Adodc1.RecordSource = SQL
On 7/4/06, De ce <[EMAIL PROTECTED]> wrote:
__._,_.___
Maaf ya Mas saya mau tanya lagi, saya lagi sedang masukkan user-usernya di query, tapi terlalu panjang dan saya ingin melanjutkan query-nya di baris yang baru namun pakai tanda apa ya supaya bisa nyambung kebawah dan tidak merah tulisannya di query tersebut? contoh:Adodc1.RecordSource = "SELECT Query1.Kode, Query1.Rinician, SUM(Query1.AE) as AE, SUM(Query1.AN) as AN, SUM(Query1.AW) as AW, SUM(Query1.DC) as DC, SUM(Query1.DD) as DD , SUM(Query1.DL) as DL, SUM(Query1.DN) as DN, SUM(Query1.EF) as EF, SUM(Query1.ES) as ES, SUM(Query1.FAS) as FAS, SUM(Query1.FS) as FS, SUM(Query1.HT) as HT, SUM(Query1.IIS) as IIS, SUM(Query1.IR) as IR, SUM(Query1.KA) as KA, SUM(Query1.KI) as KI, SUM(Query1.KS) as KS, SUM(Query1.MI) as MI, SUM(Query1.MJ) as MJ, SUM(Query1.MS) as MS, SUM(Query1.NN) as NN & _
FROM (SELECT Kode, Rinician, IIF(User='AE',Jam,0)AS AE, IIF(User='AN',Jam,0)AS AN, IIF(User='AW',Jam,0)AS AW, IIF(User='DC',Jam,0)AS DC, IIF(User='DD',Jam,0) AS DD, IIF(User='DL',Jam,0) as DL, IIF(User='DN',Jam,0) as DN, IIF(User='EF',Jam,0) as EF, IIF(User='ES',Jam,0) as ES, IIF(User='FAS',Jam,0) as FAS, IIF(User='FS',Jam,0) as FS, IIF(User='HT',Jam,0) as HT, IIF(User='IIS',Jam,0) as IIS, IIF(User='IR',Jam,0) as IR, IIF(User='KA',jam,0) as KA, IIF(User='KI',Jam,0) as KI, IIF(User='KS',Jam,0) as KS, IIF(User='MI',Jam,0) as MI, IIF(User='MJ',Jam,0) as MJ, IIF(User='MS',Jam,0) as MS, IIF(User='NN',Jam,0) as NN FROM detail)Query1 GROUP BY Query1.Kode, Query1.Rinician"Apa saya yang salah kasih tanda sambung ya & _ ?Tks.Salam,de
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.
