multiple search fields

<i><b>Originally posted by : steve (stvchez123@yahoo.com)</b></i><br />I want to have multiple search fields, and i'm trying to figure out the sql?<br /><br />If I do this, for one field, it works:<br />Query="SELECT * from belleisle_db"<br />If breed <> " " Then <br />Query = Query & " WHERE breed LIKE '%" & breed & "%'" <br />End If <br /><br />but am unsure how invoke two or more. Please steer me in the right direction:<br />Query="SELECT * from belleisle_db"<br />If breed <> " " Then <br />Query = Query & " WHERE breed LIKE '%" & breed & "%'" <br />If purpose <> " " Then <br />Query = Query & " WHERE purpose LIKE '%" & purpose & "%'" <br />End If

<i><b>Originally posted by : Graham Masters (graham_masters@hp.com)</b></i><br />You're almost there. Try:<br /><br />Query="SELECT * from belleisle_db"<br />If breed <> " " Then <br />Query = Query & " WHERE breed LIKE '%" & breed & "%'" <br />If purpose <> " " Then <br />Query = Query & " AND purpose LIKE '%" & purpose & "%'" <br />End If <br /><br /><br />------------<br />steve at 7/6/2001 11:18:25 AM<br /><br />I want to have multiple search fields, and i'm trying to figure out the sql?<br /><br />If I do this, for one field, it works:<br />Query="SELECT * from belleisle_db"<br />If breed <> " " Then <br />Query = Query & " WHERE breed LIKE '%" & breed & "%'" <br />End If <br /><br />but am unsure how invoke two or more. Please steer me in the right direction:<br />Query="SELECT * from belleisle_db"<br />If breed <> " " Then <br />Query = Query & " WHERE breed LIKE '%" & breed & "%'" <br />If purpose <> " " Then <br />Query = Query & " WHERE purpose LIKE '%" & purpose & "%'" <br />End If