I am trying to search via the sql statement, and need to select by a number (dealernumber), and by text <BR><BR>SQL = "SELECT contacts.* FROM [contacts] WHERE dealernumber = &#039" & Request("dealernumber") & "&#039 & WHERE " & request("fyear") & WHERE request("myear") & WHERE request("mmake") & WHERE request("build") & "&#039 order by tyear desc"<BR><BR>I&#039ve worked it for so long I&#039m sure that I&#039m doing something simple wrong, but I can&#039t figure it out.