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]
