Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Aug 2002
    Location
    Des Moines, Iowa, USA
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Using LIKE with a prompted value (XP)

    Is it possible to use the LIKE keyword on a prompted value in a query? For example, if a user was prompted for a company name, and entered Cargill, I was hoping to be able to extract all the different locations of the company in our database which are coupled with the word Cargill. Using the LIKE * [Enter the company name] (in a query that is attached to a form) produces a complete list of everything in our Address table and does no prompting. <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

  2. #2
    Star Lounger
    Join Date
    Aug 2002
    Location
    Des Moines, Iowa, USA
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using LIKE with a prompted value (XP)

    Disregard the problem!!! Just as I finished the post, I discovered the solution! <img src=/S/fanfare.gif border=0 alt=fanfare width=31 height=23>
    The solution was to place a LIKE before the prompt, then after the prompt, add & "*". How basic. Maybe next question will be more challenging! Happy holidays to all!

Posting Permissions

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