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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!