[belajar-access] Re: Query Total

Betul pak, tinggal tambah fungsi nz saja langsung sukses seperti yg diharapkan.

Terima kasih
Suksma

BambangMahfudin

--- In belajar-access@yahoogroups.com, "sudarsono" <jkssbma@...> wrote:
>
> coba ganti dgn :
> SELECT OrderMasuk.kode, Sum(nz(BarangMasuk.Qty),0) AS SumOfQty
> FROM OrderMasuk LEFT JOIN BarangMasuk ON OrderMasuk.kode = BarangMasuk.kode
> GROUP BY OrderMasuk.kode;
>
> '===========
> --- In belajar-access@yahoogroups.com, Zackie Bams <bambalid@> wrote:
> >
> > Bapak accessers, mohon solusi....
> >
> > Saya punya tabel 'OrderMasuk' dg field: kode,qty
> >
> > dan tabel 'BarangMasuk' dg field: tanggal,kode,qty
> >
> > Ketika saya bikin query total ( seperti gb terlampir ) record-record yg
> > belum ada/masuk dalam tabel 'BarangMasuk' tidak ada nilainya ( null).
> >
> > Sedangkan yg saya harapkan ada nilai 0 (nol)
> >
> > Mohon solusi dimana kesalahannya, Terima kasih sebelumnya.
> >
> > Salam
> > BambangMahfudin
> >
> > Query SQL :
> > SELECT OrderMasuk.kode, Sum(BarangMasuk.Qty) AS SumOfQty
> > FROM OrderMasuk LEFT JOIN BarangMasuk ON OrderMasuk.kode = BarangMasuk.kode
> > GROUP BY OrderMasuk.kode;
> >
>

------------------------------------

SPAM IS PROHIBITEDYahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/belajar-access/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/belajar-access/join
(Yahoo! ID required)

<*> To change settings via email:
belajar-access-digest@yahoogroups.com
belajar-access-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
belajar-access-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/