Re: [belajar-access] Re: Query Total

Nah ini juga contoh pemakaian nz ya mas, mohon jelaskan logika pemakaian nz di : Sum(nz(BarangMasuk.Qty),0)
tengkyu mas...

---

From: sudarsono <jkssbma@yahoo.com>
To: belajar-access@yahoogroups.com
Sent: Sun, March 20, 2011 12:49:24 PM
Subject: [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 PROHIBITED

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___