how could i add course2 with my syntax..my code doesnt work..
Code:RSonn3 "select * from tbluserinfo where course Like '" & text1.text & "%'" AND course2 Like '" & text1.text "'%"
Printable View
how could i add course2 with my syntax..my code doesnt work..
Code:RSonn3 "select * from tbluserinfo where course Like '" & text1.text & "%'" AND course2 Like '" & text1.text "'%"
its like combining this two codes by i dont know how to combine them.
Code:
RSconn3 "select *from tbluserinfo where course Like '" & Text1.Text & "%'"
RSconn3 "select *from tbluserinfo where course2 Like '" & Text1.Text & "%'"
Use OR instead of AND for one or the other.
thanks alot.