kalo saya pake MySQL 5.0.19 pake cara begini untuk menghadapi situasi
macam itu :
SELECT KodeBarang,
*IFNULL((SELECT QtySA FROM qrySA_Barang WHERE Gudang='Counter' AND
KodeBarang=tblKartuStok_barang.KodeBarang AND BlnSA=3
AND ThSA=2006)), 0) AS SA*, SUM(QtyKS) AS Jumlah FROM tblkartustok_barang
WHERE Gudang='Counter' AND MONTH(TglTrans)=3 AND YEAR(TglTrans)=2006
GROUP BY KodeBarang
thx
azam wrote:
> Terima kasih rekan2.
> Sori kyaknya pertanyaan saya kurang jelas, jd byk alternatif jwbn.
>
> Saya punya tabel spt ini
>
> Nosbbx Saldoakhir
> 218120 0
> 218121 0
> 218220 200
> 218221 0
> 218921 200
> 218922 100
>
> kode program saya
>
> rs.open "Select sum(saldoakhir) as saldo from tabel where nosbbx like
> '2181%'
>
> yang ingin saya cari adalah jumlah saldoakhir nosbbx
> 2181xxx,2182xxx,2183xxx dst.
>
> Sedangkan nosbbx 2183xxx kan belum ada. Saya ingin jika nosbbx ada, maka
> saldo ditampilkan sesuai dg data, tp jika nosbbx ga ada, maka saldo = 0
>
> Contoh : utk nosbbx 2181xxx, saldo = 0
> utk nosbbx 2182xxx, saldo = 200
> utk nosbbx 2183xxx, saldo = 0 (pngennya)
> utk nosbbx 2189xxx, saldo = 300
>
> cara pengecekan saya
> if isnull(rs) then
> saldo=rs("saldo")
> else
> saldo = 0
> end if
>
> klo sy tambahkan field nosbbx pd rs.open ..., artinya saya harus group
> by nosbbx shg yg akan ditampilkan adl per record (bukan jumlahnya).
>
> Gmn solusinya selain menambah data pd field nosbbx. Tnx b4
>
>
> Best Regards,
>
>
> Azam
>
>
>
>
>
> Wahana Programmer Groups Links
>
>
>
>
>
>
> ------------------------------------------------------------------------
> YAHOO! GROUPS LINKS
>
> * Visit your group "Programmer-VB
> <http://groups.yahoo.com/group/Programmer-VB>" on the web.
>
> * To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
> ------------------------------------------------------------------------
>
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
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
