It is not difficult to do what you are asking however there is just not enough info here to really help you. Please post more info or email me more at firstname.lastname@example.org and I will be glad to help you out.
Like Mike said (post below), we do need to know a little more. However here is a little quick one. Not recomended for larger db's with lots of records (indexes do not work when done like this).<BR><BR>'SQL String for one field<BR>Select * From t_your_table where f_one_field LIKE '%" & some_variable & "%'"<BR><BR>'SQL String for two fields both must match.<BR>'Just switch the AND to a OR for matches in any <BR>'of the fields. _THIS_NOT_THE_FASTEST_WAY_<BR>Select * From t_your_table Where f_one_field LIKE '%" & Some_variable & "%' AND f_two_field LIKE '%" & Some_variable & "%'"<BR><BR>hope this gets you pointed in the right direction.<BR>DRUG_DEALER