Results 1 to 2 of 2
  1. #1
    jasabel is offline Novice
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Posts
    10

    How to find multiple words in a string in any order

    Hi.


    I am getting in trouble with the following query...

    We have stored in a field (call it Knowledge) a number of subjects like "C++, Java, PHP, Windows, Java Script", freetext type, comma splitted.

    We need to find al the records that match a subset of knowledgements, in any order, as for example "Windows and C++"

    Thanks in advance

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    this doesn't say much. you're probably looking at using INSTR() and a call to a function where you can utilize the SPLIT() function with a "," delimiter.

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

Similar Threads

  1. Replies: 15
    Last Post: 10-01-2015, 10:06 AM
  2. Creating a String in VBA over multiple lines
    By Mazdaspeed6 in forum Programming
    Replies: 13
    Last Post: 01-03-2011, 12:32 PM
  3. Multiple Criteria in a string
    By cksm4 in forum Programming
    Replies: 3
    Last Post: 08-04-2010, 11:54 AM
  4. order by - string and numeric
    By pen in forum Queries
    Replies: 10
    Last Post: 05-20-2009, 06:29 AM
  5. Find existing record with multiple criteria
    By TheWedgie in forum Forms
    Replies: 1
    Last Post: 03-25-2009, 10:24 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