Home > IT Answers > Development > Query Criteria question
Help

Question

  Asked: Apr 24 2008   12:08 AM GMT
  Asked by: Jena

Query Criteria question


Query

I am designing a query. One of the fields in the query is "department". In my form there is a pull down menu with about 20 departments. In my query, I am making the department field have a criteria so that when you run the query, it asks for which department. However, if you do not type the department name exactly as in the list, you do not get any matches. Is there any way when running a query with a criteria to have it ask for a field but show a pull down menu when it asks...so that you don't necessarily have to know exactly how something is spelled?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

CREATE ANSWER
View History
Start this Answer and Earn your Knowledge Points!

By clicking "Create Answer", you can write the answer to this question that can be improved upon by your peers using the Answer Wiki.

Browse more Questions and Answers on Development.

Looking for relevant Development Whitepapers? Visit the SearchSQLServer.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register