Buat Upie... Upie gini aja sintaknya :
Kalo saran dari saya sih untuk tanggal nya ada 2 masukan aja 1. TANGGAL AWAL (Reg) dan 2. TANGGAL AKHIR (Reg2) strSQL = "Select * from Member where Tgl >= #" & Format(Reg, "MM/DD/YYYY") & "# and Tgl <= #" & Format(Reg2, "MM/DD/YYYY") & "# " atau kalo mau tetep tanggalnya satu masukkan gini aja strSQL = "Select * from Member where Tgl >= #" & Format(Reg, "MM/DD/YYYY") & "# " thanks agung ----- Original Message ----- From: "opie" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, February 09, 2006 6:54 PM Subject: [indoprog-vb] Query tanggal di Access melalui VB? > Halo, > mau nanya nih > aku pake VB dgn Access > aku coba query... > > 1. select * from member where tgl>='" & reg.value & "' > 2. select * from member where tgl>='" & format(reg.value,"mm/dd/yyyy") & "' > > dua macam query ini sll muncul error > "Data type mismatch in criteria" > > masalahnya dimana ya? > > di Access aku pake short date > reg itu adalah dtpicker > > terima kasih > salam > Opie > > > > [Non-text portions of this message have been removed] > > > > Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED] > > Ikuti juga forum diskusi VB.net dengan > mengirim email kosong ke [EMAIL PROTECTED] > > Yahoo! Groups Links > > > > > > > > Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED] Ikuti juga forum diskusi VB.net dengan mengirim email kosong ke [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indoprog-vb/ <*> 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/
