Im a new starter in ASP and have created a basic site to display, add, edit and delete records from my database. Im trying to create an adv search that basically builds up the SQL Where statement with AND's! A number of text forms where the keywords entered should search those fields and a number of dropdown forms populated with data from looup tables that I have so usera can select also. All the forms should query together when submitted (AND queries etc). Help is much appreciated. Thanx.