[belajar-access] Query Total [1 Attachment]

[Attachment(s) from Zackie Bams included below]

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;
 

Attachment(s) from Zackie Bams

1 of 1 File(s)

Query.jpg

__._,_.___

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

__,_._,___