how to use select command using to condition
-
Dear all I need your favor due to my case, I wondering know how to write Select Command with two condition. here is I give you my description about my need in my form there in two textbox (textbox1 and textbox2) could you tell me how to write the Select command to involved both of that Textbox using "And" ?, so far I only know one condition for select command as the follow word" " Select * from table1 where (idno='" & textbox1.text & "')",conection) and now I need to combine select command for access textbox1 and textbox2 value. Thank you Best regards ICE
-
Dear all I need your favor due to my case, I wondering know how to write Select Command with two condition. here is I give you my description about my need in my form there in two textbox (textbox1 and textbox2) could you tell me how to write the Select command to involved both of that Textbox using "And" ?, so far I only know one condition for select command as the follow word" " Select * from table1 where (idno='" & textbox1.text & "')",conection) and now I need to combine select command for access textbox1 and textbox2 value. Thank you Best regards ICE