Coba ini, maksudnya kamu menggunakan 2 DTpicker dan mau berdasarkan tanggal yang di DTpicker
sql = "select * from transaksi where tgl_trans between #" & Datepicker1.value "# AND #" & Datepicker2.value moga membantu.. --- Wahyu D S S <[EMAIL PROTECTED]> wrote: > Dear all VB, > > Mohon petunjuknya, saya punya tabel transaksi > seperti ini > > kd | tgl_trans | total | > ----------------------- > 1 | 01/10/2006 | 10 | > 2 | 11/10/2006 | 20 | > 3 | 21/10/2006 | 15 | > 4 | 26/10/2006 | 40 | > 5 | 30/11/2006 | 26 | > 6 | 01/11/2006 | 47 | > 7 | 09/11/2006 | 38 | > 8 | 15/11/2006 | 72 | > ----------------------- > > format tanggal dalam indonesia dd/MM/yyyy, sama > seperti setingan komputer. > > Nah yg sy ingin tanyakan gimana caranya menampilkan > transaksi yang hanya > tanggal 01/11/2006 - 30/10/2006 > sy pkai query begini : > sql = "select * from transaksi where tgl_trans > between #" & > me.tgl_awal.value & #" AND #" & me.tgl_akhir.value & > "#" > * me.tgl_awal.value = Datepicker (01/10/2006) > * me.tgl_akhir.value = Datepicker (30/10/2006) > tapi yang muncul datanya malah semuanya, klo sy > ganti tgl_awal menjadi > 15/10/2006 yang muncul transaksi dari 21/10/2006 - > 30/11/2006. Spertinya > dia hanya baca awalnya aja (tglnya aja). > > Mohon bantuannya semua para suhu & master vb, coz > udah deadline. > > Wahyu. > > > > > > > [Non-text portions of this message have been > removed] > > ____________________________________________________________________________________ Cheap Talk? Check out Yahoo! Messenger's low PC-to-Phone call rates (http://voice.yahoo.com) Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED] Bagi terjangkit virus lokal, zip virus tersebut dan kirim ke [EMAIL PROTECTED], kami akan membuat removalnya untuk anda. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indoprog-vb/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indoprog-vb/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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/
