Saya coba memberi jawaban moga2 bener (pertamakali loh kasi jawaban di milis
ini)
dan saran mbak lilis soal aturan milis saya setuju, saya salah satu yang
jarang ngucapin terima kasih, saya juga mohon maaf soal itu dan pada kesempatan
ini saya ngucapin banyak-banyak terima kasih kepada para anggota milis, saya
banyak menambah ilmu di milis ini. sekali lagi terima kasih
set rsBarang as new adodb.recordset
csql = "SELECT Barang.nm_buah, Sum(Barang.Jml) AS SumOfJml,Sum(Barang.Harga)
AS SumOfHarga FROM Barang GROUP BY Barang.nm_buah;"
rsBArang.Open Csql, DNS, adOpenStatic, adLockOptimistic
if rsBArang.recordcount < 1 then exit sub
set rsBarangView as new adodb.recordset
csql = "Select * from BArang_View
rsBArangView.open csql,DNS,adOpenstatic,AdLockOptimistic
Do
with rsBarang
.addnew
!nm_buah = rsBarang!nm_buah
!jml = rsBarang!sumofJml
!Harga = rsBarang!SumofHaraga
.update
end with
rsBarang.movenext
loop until rsBarang.eof
Karya Gunawan <[EMAIL PROTECTED]> wrote:
ok.. langsung aja ya....
saya cuma ingin memberikan tutorialnya berupa ebook.
silahkan download di sini http://jagungblog.blogspot.com
McBoenBoen <[EMAIL PROTECTED]> wrote: Saya coba dengan scrip ini masih error
mas,
cn.Execute "INSERT INTO View_stock_pulsa_dwnl " & _
"SELECT * FROM tbl_stock_pulsa, SUM(tsel_simpati5)as s5, sum(tsel_simpati10) as
s10" & _
"Group by nm_toko"
NOTE : Field ke 2 tabel persis sama
salam,
mc
Mario Indra Jaya <[EMAIL PROTECTED]> wrote:
Coba query ini :
SELECT nm_buah, SUM(jml) as jml1, SUM(harga) as harga 1
INTO Tabel_Barang_view
from Tabel_Barang
GROUP BY nm_buah
Best Regards,
_____
From: McBoenBoen [mailto:[EMAIL PROTECTED]
Sent: 31 Mei 2007 19:22
To: [email protected]; Waroeng VB; [EMAIL PROTECTED]
Subject: [indoprog-vb] query pengelompokan
dear all Vbers,
mohon pencerahannya,
bagaimana caranya query memindahkan record dari tabel Barang ke tabel
barang_vew dengan pengelompokan berdasarkan nama buah dan jumlahnya ditotal
contoh:
Tabel Barang
nm_buah jml harga
Jeruk 20 200
Apel 11 100
Nanas 22 200
Anggur 33 300
Jeruk 20 200
Apel 11 100
Nanas 22 200
Anggur 33 300
hasilnya dimasukkan ke tbale Barang_view dengan hasil sepeti ini:
Jeruk 40 400
Apel 22 200
Nanas 44 400
Anggur 66 600
database access 2003
terimakasih atas jawabannya.
salam,,
mc
---------------------------------
Choose the right car based on your needs. Check out Yahoo! Autos new Car
Finder tool.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
---------------------------------
Shape Yahoo! in your own image. Join our Network Research Panel today!
[Non-text portions of this message have been removed]
---------------------------------
TV dinner still cooling?
Check out "Tonight's Picks" on Yahoo! TV.
[Non-text portions of this message have been removed]
---------------------------------
Don't pick lemons.
See all the new 2007 cars at Yahoo! Autos.
[Non-text portions of this message have been removed]
