Results 1 to 3 of 3
  1. #1
    OB7 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Oct 2013
    Posts
    16

    Query criteria w/ multiple text values--too many to type--can I refer to a text file?

    My table contains a Customer ID field. The Customer IDs are 6-digits and are stored as text. I would like to do a query which pulls records for 100 specific Customer IDs, and I currently have those IDs saved in a text file.



    However, in the Criteria field within Design View, I don't want to manually type in:

    <Customer ID1> OR <Customer ID2> OR <CustomerID3> OR.... <Customer ID100>

    Is there some way that I can simply refer to the text file which contains my list of Customer IDs in the following format:

    Customer ID1
    Customer ID2
    ...
    Customer ID100

    If not, can you recommend any other shortcut for entering multiple text values in the Criteria field of the Design View?

    Thank you!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    No dont type them in the field,
    Build a select query by puttin the customers wanted in a 'Find' table. Link the find table to your main table on [Customer IDs].

  3. #3
    OB7 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Oct 2013
    Posts
    16
    Quote Originally Posted by ranman256 View Post
    No dont type them in the field,
    Build a select query by puttin the customers wanted in a 'Find' table. Link the find table to your main table on [Customer IDs].
    Thank you, ranman 256! That'll do the trick!

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

Similar Threads

  1. How to use multiple values in text search?
    By selvakumar.arc in forum Access
    Replies: 3
    Last Post: 05-02-2014, 12:36 PM
  2. Design a text box for multiple values
    By gilbertvb3 in forum Forms
    Replies: 1
    Last Post: 07-30-2013, 08:51 PM
  3. Replies: 2
    Last Post: 05-16-2012, 04:45 PM
  4. Replies: 4
    Last Post: 08-31-2011, 12:36 PM
  5. Displaying multiple text values in crosstab query
    By MFlood7356 in forum Queries
    Replies: 6
    Last Post: 06-28-2011, 11:30 AM

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