Results 1 to 4 of 4
  1. #1
    selvakumar.arc is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2013
    Posts
    49

    Smile How to use multiple values in text search?


    Hi,My ms access application is developed using MS Access 2010. I am trying to filter the row based on the multiple values in a column. But I am not getting any result.Ex: In my datasheet I have a column as "UserName" and it has 3 row as "ABC", "XYZ" and "LMN". I tried to search using Text Search and given ABC OR LMN for search but I am not getting any result.How can I use multiple values in Text search?ThanksSelvakumar R

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    The OR operator should provide the results you are looking for. Can you post the code you are using?

  3. #3
    selvakumar.arc is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2013
    Posts
    49
    I am searching values from Datasheet view itself. In datasheet view - right click the cell - Text Filters - Equals - popup will appear and provide ABC OR LMN as per example.

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Do the 1st filter, then click the icon: ADVANCED FILTER/SORT. This 'edits' the filter.
    Then you can all ALL the rest of your filters here.
    (I would use queries myself.)

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

Similar Threads

  1. Design a text box for multiple values
    By gilbertvb3 in forum Forms
    Replies: 1
    Last Post: 07-30-2013, 08:51 PM
  2. Replies: 1
    Last Post: 05-24-2013, 02:44 AM
  3. Replies: 1
    Last Post: 03-06-2013, 05:51 AM
  4. Search multiple fields from one text box
    By tommy93 in forum Queries
    Replies: 21
    Last Post: 01-10-2012, 02:18 AM
  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