[belajar-access] stok report

dear master access,

 

saya mau tny gmn nambahin saldo awal untuk stok report saya.

adapun query yang telah saya buat sbb:

 

SELECT DISTINCT stock.Tanggal, stock.Category, stock.Merk, stock.Type, Sum(stock.Masuk) AS Masuk, Sum(stock.Keluar) AS Keluar, sum(masuk)-sum(keluar)<tanggal + masuk - keluar as saldo
FROM stock
GROUP BY stock.Tanggal, stock.Category, stock.Merk, stock.Type
HAVING (((stock.Tanggal) Between [Forms]![Laporan]![Text1] And [Forms]![Laporan]![Text3]));

 

mohon bantu ya...

 

 

__._,_.___

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

__,_._,___