Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Using Wildcards in a Parameter (2000)

    Is it possible to use wildcards in a query parameter? I need the query to return records that match a portion of a field rather than an exact match. The field in question contains text such as K1234(1), K1234(2), K1234(3), K2234(1), K2234(2), etc. The result I want is each instance of K1234 (in this example, three records). I've tried entering K1234*, K1234[*], K1234"*" without success. If it's possible to do, what is the syntax? If it's not possible, is there some other way to do this?

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

    Re: Using Wildcards in a Parameter (2000)

    Method 1: the user types in the wildcard. Set the criteria to<pre>Like [Enter Value]</pre>

    The user would type K1234* to find all values starting with K1234, or K*2 to find all values starting with K and ending in 2.

    Method 2: the wildcard is added in the query. Set the criteria to<pre>Like [Enter Value]&"*"</pre>

    The user would type K1234 to find all values starting with K1234. It's not possible to enter different search patterns.

  3. #3
    New Lounger
    Join Date
    Mar 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using Wildcards in a Parameter (2000)

    Thanks! Method 1 is what I was looking for. <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

Posting Permissions

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