SQL Syntax for search MSAccess Database from a html dropdown FORM page using ASP

<i><b>Originally posted by : Sudip (sudip@css.cmmacs.ernet.in)</b></i><br />what is the sql syntax for the query like<br />select field (from a dropdown menu of 4 fields, select name=A) put query (text box name=b)and select one boolean operator(name=C)and select other field (from same type of dropdown menu of 4 fields, name=D)and put another query(text box name=E)?<br />Ex.<br />search: name=aaa AND division=bbb<br />I am using MSAccss and DSN less connection. Simple sting search query (LIKE %) is working excellent.<br />Please help me.<br /><br />