coba pakai tanda petik satu dgn asumsi nip ada varchar:
and {tbl_rawat.nip} ='" & cmbnn.Text & "'"----- Original Message ---- From: iwan gunawan <[EMAIL PROTECTED]> To: [email protected]; [EMAIL PROTECTED] Sent: Monday, July 7, 2008 16:00:10 Subject: [Programmer-VB] CR dgn 3 filter gmn? Guys, gw bikin filter di Cr dgn periode dah bisa, ini codingnya : str = "{tbl_rawat. tanggal}>#" & Format(DTPicker1. Value, "MM-DD-YYYY" ) & "# and {tbl_rawat.tanggal}< #" & Format(DTPicker2. Value, "MM-DD-YYYY" ) & "# " nah kalo gw mo filter lagi berdasarkan nip gmn? gw dah coba tambah coding kayak gini, tp ga bisa. and {tbl_rawat.nip} #" & cmbnn.Text & "#" bagi donk elmunya, thanks. Send instant messages to your online friends http://uk.messenger.yahoo.com
