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

    Query question (2003/11.5614.8122)

    There must be an easy way to do this, but it escapes me. I want to create a query to search a single table with 700+ records. I'm searching in a single field for a single term. The problem seems to be that the field contains up to ten terms; I want to find all records that contain a specific word in the field. For example: In one record the field called "Index" contains four names -- Bob, Mary, Tim, Joe. In another record the field "Index" contains five names -- Sandy, Hans, Clark, Mary, Joe. I want to find all records that contain "Mary." So far, all I've been able to do is find records that start with Mary. How do you tell Access to find all records that INCLUDE the name "Mary," anywhere in the field "Index?"

    Thanks for any help.

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

    Re: Query question (2003/11.5614.8122)

    Set the criteria for the Index field to
    <code>
    Like "*Mary*"
    </code>
    The wildcard characters * before and after the word Mary specify that any number of characters can come before or after Mary, i.e. the field value can be anything as long as it contains the word Mary.

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

    Re: Query question (2003/11.5614.8122)

    You're a life-saver, Hans! Thank you!

Posting Permissions

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