Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Dec 2001
    Location
    Bordentown, New Jersey, USA
    Posts
    405
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query Criteria Too Strict (way too strict!!!) (2003)

    Hello Again...

    In my company's database...which keeps architectural info & conditions for a homeowners' association...I need to run queries from time to time...that do not have a strict criteria definition.

    My inspector in the field, for example, enters info on 'Satellite Dishes'...but there will always be different circumstances as to condition...meaning that the entered language always differs.

    So...Access queries won't show results unless the specific phrase is found.

    I need to be able to loosen up those criteria boundaries. I want to be able to run a query; & specify say, "Satellite Dish" as the criteria...& then get results on every entry that has the words 'satellite dish' mentioned in the records. Can this be done???

    Thanks,


    mark4man
    Access 2003
    ADK Pro Audio Quad Pro, w/ Intel Core i7 2600 CPU | 8 GB DDR3-1600 RAM | Seagate 500 GB SATA II (Primary) HD | Seagate 1 TB SATA II (Audio Data) HD | Win 7 Pro 64-Bit | Lynx Aurora8 ~ AES16 | Universal Audio UAD-1 | Cakewalk SONAR PE XI | Steinberg WaveLab 7 | NI Komplete 5 | Band-In-A-Box 2012

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

    Re: Query Criteria Too Strict (way too strict!!!) (2003)

    If you enter
    <code>
    Like "*satellite dish*"
    </code>
    in the criteria line, all records where the field contains satellite dish will be returned, i.e. the following values will all qualify:

    Big satellite dish
    Satellite dishes
    20 satellite dishes and more
    Blue satellite dishcloths

    but not

    lite dishes

    Does that do what you want?

  3. #3
    4 Star Lounger
    Join Date
    Dec 2001
    Location
    Bordentown, New Jersey, USA
    Posts
    405
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query Criteria Too Strict (way too strict!!!) (2003)

    Hans...

    That works !!!

    Thanks very much,

    mark4man
    ADK Pro Audio Quad Pro, w/ Intel Core i7 2600 CPU | 8 GB DDR3-1600 RAM | Seagate 500 GB SATA II (Primary) HD | Seagate 1 TB SATA II (Audio Data) HD | Win 7 Pro 64-Bit | Lynx Aurora8 ~ AES16 | Universal Audio UAD-1 | Cakewalk SONAR PE XI | Steinberg WaveLab 7 | NI Komplete 5 | Band-In-A-Box 2012

Posting Permissions

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