[belajar-access] running sum

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

__,_._,___