Salam VB,
sSQL= "SELECT * FROM NAMATABEL WHERE DIVISI='C' AND TANGGAL >= #' &
DTPICKER1.VALUE & "#' AND TANGGAL <= #' & DTPICKER2.VALUE & "#'"
trus buat looping
nJlh_A=0
nJlh_B=0
for i=1 to rs.recordcount
nJlh_A=Jlh_A+rs.fields("A")
nJlh_B=Jlh_B+rs.fields("B")
rs.movenext
next i
Semoga membantu...
________________________________
GENERASI COMPUTER
Berbagi Ilmu Visual Basic Bagi Pemula
http://www.generasicomputer.com
Hp. 08126514562
________________________________
________________________________
From: sodikin vk <[email protected]>
To: [email protected]
Sent: Fri, December 4, 2009 11:13:03 AM
Subject: [Programmer-VB] Menjumlah
Selamat siang master semua
Saya punya tabel
Tanggal Divisi A B
1/12/09 C 5 5
3/12/09 C 5 5
25/12/09 D 5 5
Saya ingin Jumlah total dari divisi C dari tanggal 1/12/09 s/d 3/12/09
bagaimana code nya?
terima kasih
________________________________
New Email names for you!
Get the Email name you've always wanted on the new @ymail and @rocketmail.
Hurry before someone else does!
