In a general outline, what is the best way to convert a users search criteria into a SQL statement? <BR>More detail: they can search by order number, date, sales rep or order status. The user may mix and match criteria that is formed into a SQL statement. Such as:<BR>SELECT * FROM tbl_sales where date = &#060;inputed date&#062; and salesRep = &#060;inputed sale rep&#062;.<BR>The problem arises in linking there parameters into one statement.<BR><BR>Thanks.<BR><BR>Conrad