Re: [Programmer-VB] Query di VB dg database Access

Tue, 06 Jun 2006 23:45:24 -0700

setelah kutambahkan .tbbarang.nama errornya berubah menjadi
preview : -2147217904 - No Value given for one or more required parameters
 
 
----- Original Message -----
Sent: Wednesday, June 07, 2006 11:58 AM
Subject: Re: [Programmer-VB] Query di VB dg database Access

Halo Eko,
Kalo gak salah eko ada yang kelupaan.
 
Select tbdetail.kodebrg,tbbarang.Nama,sum(tbdetail.jumlah) as laris from tbdetail left join tbbarang on tbdetail.kodebrg = tbbarang.kodebrg group by tbdetail.kodebrg,tbbarang.Nama order by laris desc
 
Regards
Padu Arsana iW
 
 


Eko <[EMAIL PROTECTED]> wrote:
saya ada buat query di vb sbk:
 
select tbdetail.kodebrg,tbbarang.Nama,sum(tbdetail.jumlah) as laris from tbdetail left join tbbarang
on tbdetail.kodebrg = tbbarang.kodebrg group by tbdetail.kodebrg order by laris desc
 
kenapa selalu muncul
Preview : -2147217887 - Tou tried to execute a query that does not include the specified _expression_ 'Nama'
as part of an aggregate function
 
struktur tabel di ms access nya sbk:
TbBarang (KodeBrg,Nama,HargaBeli,HargaJual)
TbDetail (NoNota,KodeBrg,HargaJual,Jumlah)
 
padahal klo saya tes di mysql front, bisa jalan
 

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

__._,_.___

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