Re: [belajar-access] running sum

Mainin di query cak sum:
SELECT 'J' AS TrxType, JH.ID, JH.trx, JH.tgl, JD.qty, JD.price, -(JD.qty * JD.price) AS  Amount FROM tblpenjualanheader AS JH INNER JOIN tblPenjualanDetail as JD ON JH.trx = JD.trx
UNION ALL
SELECT 'B' AS TrxType, BH.ID, BH.trx, BH.tgl, BD.qty, BD.price, BD.qty * BD.price AS Amount FROM tblpembelianheader as BH INNER JOIN tblpembeliandetail as BD ON BH.trx = BD.trx

Sekarang tinggal group by TrxType di report, dan jalankan running sum over group.



aksan kurdin





On 4/7/2011 9:27 AM, Sumiyanto - wrote:

 

mengenai running sum, ada beberapa hal yang ingin saya tanyakan: tblPenjualanHeader(ID, trx, tgl) tblPenjualanDetail(ID, trx, qty, price) tblPembelianHeader(ID, trx, tgl) tblPembelianDetail (ID, trx, qty, price) jika di buat query union antara transaksi penjualan dan pembelian otomatis terdapat record ID yang mungkin sama, sehingga dalam kasus running sum berdasarkan ID tidak bisa terpenuhi. Mohon saran tentang running sum... berikut link tentang running sum: http://support.microsoft.com/search/default.aspx?mode=r&query=running+sum+ms+access&spid=global&catalog=LCID%3D1033&1033comm=1&ast=25&ast=28&ast=30&ast=31&res=10 http://office.microsoft.com/en-us/access-help/calculate-a-running-sum-cumulative-total-HP005187388.aspx http://support.microsoft.com/kb/205183 http://office.microsoft.com/en-us/access-help/summing-in-reports-HA001122444.aspx http://office.microsoft.com/en-us/access-help/create-an-expression-HA010341590.aspx?CTT=5&origin=HA010341571 http://support.microsoft.com/kb/208714 http://office.microsoft.com/en-us/access-help/sum-data-by-using-a-query-HA010096310.aspx http://support.microsoft.com/kb/210338 http://support.microsoft.com/kb/296249 Salam, Sumiyanto

__._,_.___

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

__,_._,___