Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2003
    Posts
    18

    Unanswered: Returning text as a Parameter

    The question is how to return the text that I want from my parameter? Means I want to look for a certain word in the name of a company and the query will run the companies' name that contain that word.

    I don't want to specify the word in my SQL statement I want to leave it open. I've done it with a date and the criteria for the parameter is:
    Like [Date:].

    In SQL it's translated like this:
    WHERE Table.OrderDate = [Date:]
    And I will enter the date that I want. Is there a way to do it with text to return all the companies' names containing the word that I want on my parameter?

    Thanks for the help

  2. #2
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    Like [Please Enter Company Name] & *

    this will return all values that start with whatevern they type

    ie

    EX will return Exxon and Excel

    If you want just what is rtyped verbatim

    Like [Please Enter Company Name]

  3. #3
    Join Date
    Jul 2003
    Posts
    18

    Talking

    It's working, thanks a lot for the help, It's not easy being a beginner

  4. #4
    Join Date
    Jul 2003
    Posts
    18
    Would you know how to return all the records between any values that I would enter?

    I have an Order Amount Field and I would like to return all the records between Paramter 1 which is Order Amount 1 and Parameter 2 which Order Amount 2. I want to specify my order amount when the parameter pop up.

    WHERE OrderAmount Between .... And ....

    Any Suggestions, thanks for the help

  5. #5
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    Between [Enter Start Number] and [Enter Last Number]

Posting Permissions

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