Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2008

    Query Criteria

    I am designing a query in an access database that is linked to a form and report. One of the fields in the query is "department". In my form there is a pull down menu (combo box) 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 that you don't necessarily have to know exactly how something is spelled? I would appreciate any help you can give.

  2. #2
    jya is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2007
    Offhand, I am not aware of being able to do what you are specifically asking for.

    What about using wildcards in your criteria? At least it will allow you type in part of a department.

    Like "*" & [Enter a department] & "*"

    Depending on what you are trying to accomplish, applying a form filter or writing vba code may get you what you need.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Query Criteria
    By Texaine in forum Queries
    Replies: 1
    Last Post: 01-24-2018, 02:36 PM
  2. crosstab query criteria
    By Sharron in forum Queries
    Replies: 3
    Last Post: 12-15-2011, 04:31 AM
  3. Query Criteria
    By jena in forum Access
    Replies: 1
    Last Post: 08-03-2008, 04:08 AM
  4. Need help with tables and query criteria
    By DevintheDude in forum Access
    Replies: 0
    Last Post: 09-12-2007, 08:41 AM
  5. Functions in Query Criteria
    By hraup in forum Queries
    Replies: 1
    Last Post: 10-06-2006, 06:41 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums