Microsoft Excel Webinar

Results 1 to 3 of 3

Thread: Search for a list of keywords in a string

  1. #1

    Search for a list of keywords in a string

    Hi,

    I have a access database that has a table containing some keywords and those keywords are mapped to some text. I have a functionality which allows users to upload PO data to the access database. this PO data has some Item text. I want to use this Item text and compare it to the keywords table and apply the rules for the keywords where the keywords match the words in the Item text. Please let me know how can we do this

    Thanks
    Vishal

  2. #2
    You can use the InStr function to locate a specific string within a string. This is one option for what you want to do.
    -Randy Shea
    I'm a programmer, but I'm also pro-grammar!
    If your issue is resolved, please use Thread Tools to mark your thread as Solved!

    PODA (Professional Office Developers Association) | Certifiable | MOS: Access 2003


  3. #3
    You can also do it with a Query. In the Where clause use Like with wildcards.
    Boyd Trimmell aka HiTechCoach
    Microsoft MVP - Access Expert

    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •