My Database column include Name,Designation,Department,Telphone ..etc
may i know how to make the sql select statement to search for the above?
currently i tried this but only allow me to search with Name.
strSQL = "SELECT * FROM Info WHERE INSTR(Info.Name,'" & strSearch & "')"
Thanks