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

Eko Wed, 07 Jun 2006 00:15:27 -0700

ok..makasih

setelah ngikuti sarannya mas Sistyo dan mas Padu serta tadi 1 lagi saya lupa namanya

query-nya udah bener

makasih

----- Original Message -----

From: Sistyo Alfan Tribowo

To: [email protected]

Sent: Wednesday, June 07, 2006 1:46 PM

Subject: RE: [Programmer-VB] Query di VB dg database Access

Replace order by laris with order by sum(tbdetail.jumlah)

From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Eko
Sent: Wednesday, June 07, 2006 1:41 PM
To: [email protected]
Subject: Re: [Programmer-VB] Query di VB dg database Access

setelah kutambahkan .tbbarang.nama errornya berubah menjadi

preview : -2147217904 - No Value given for one or more required parameters

----- Original Message -----

From: Padu Arsana iW

To: [email protected]

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

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.

__,_._,___

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

Kirim email ke