Access Search query

I'm trying to create a query that will allow users to search multiple field. For example, they want to enter the Appraisal Type, AND/OR the date range (from-to), AND/OR the Sale Price range (from-to). The query is set up for all the fields except for the date range and the sale price range. The users will use an unbounded form named frmCommercialSearchEngine. The Query is called Query Commercial Search. Please note that the qeury was designed using the SQL view. Please help. Database sample is attached. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. ## Platform access 2000