Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Nov 2006
    Location
    Phoenix, Arizona, USA
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    'Find' w/multiple terms (2003)

    I thought I understood how to do this, but apparently not. My records have text fields with many words. I'd like to do a simple "find" for records that match two or more specific words. In Find | Find What: I've tried (for example) "*summer*" & "*fish*" and didn't get any hits, even though there are several records that have both words in the field I'm searching. I've also tried with a comma instead of an ampersand and by substituting the word AND for the ampersand. No results. How is this supposed to be done?
    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 'Find' w/multiple terms (2003)

    You cannot use the Find dialog to search for the occurrence of several words, except if you're searching for an entire phrase, e.g. you can search for the phrase white fish, but not for the occurrence of both white and fish.
    You can use Form Filter (or Advanced Filter/Sort..) to select records that meet the criteria:
    - Select Records | Filter | Form Filter.
    - Enter the following in the relevant field to search for records that contain both the word white and the word fish in the field:
    <code>
    Like "*white*" And Like "*fish*"
    </code>
    - Click the Apply Filter button on the toolbar.

  3. #3
    Star Lounger
    Join Date
    Nov 2006
    Location
    Phoenix, Arizona, USA
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Find' w/multiple terms (2003)

    Great.Thanks, Hans!

Posting Permissions

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