[belajar-access] Re: Query Total

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/