I have a database that I want to search and display all of the results 
that meet a certain criteria. The site has apps for the Palm OS, and the 
fields that I am searching include:

color - value of 'color' for color program, 'B&W' for black and white
license - either 'free', 'demo', or 'shareware'
rating - from 1-5, 5=best

I have a search using dropdown boxes to display only the results that meet 
the criteria that the user searches for. I am having trouble with the SQL 
query to return the results that I want. I would also like the search to 
be able to handle a search where a user does not select a preference

My current attempt returns a http 505 error:

SQL_query = "SELECT * FROM Table1 WHERE color IS '%" & Replace
(By_color, "'", "''") & "%' AND license IS '%" & Replace
(By_license, "'", "''") & "%' AND rating > By_rating"