Query either fields via text input and wildcards?
Posted on 2007-10-03
I have a very simple table with four fields: lastname, firstname, mp and ext and I have a form for searching these records with two input text boxes for lastname and firstname.
I have managed to work it so if I type say Smith into the lastname input text box and click a button a query will show all the records with the last name Smith.
I want it to work so I can either type in the surname or the firstname input box to give me query results but without having to have seperate queries and buttons e.g serach by lastname, search by first name.
Also how can I make it take wildcards eg. if I type sm it will give me smith, small etc?