Are you searching for one term in multiple fields or multiple terms? If only one term, then you may use 'WHERE Field1 = term1 AND Field2 = term2'. If multiple terms, do you want all terms to be in one field, or either/or? All in one field is just a variation of the above WHERE statement with additional terms specfied for each field. It gets much more complicated if you want to search for multiple terms in either/or of multiple fields.