Results 1 to 4 of 4
  1. #1
    Join Date
    May 2004
    Posts
    38

    Unanswered: Enter Parameter Value

    Hi,

    Sorry if this is a stupid question, but I'd like to use the "Enter Parameter Value" capability in a query and report (where for example you put in [name] in criteria of a query) and then when you run the query it prompts for a name in the "Enter Parameter Value" box.

    The problem I'm having is I don't know how to set it up so you can enter more than one name, like if you want it to search for "John" or "Steve" or "Amy"....... The Enter Parameter Value box only allows for one name.

    How do I do this ?
    Thanks !

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Try this in criteria:
    [name1] Or [name2] Or [name3]

  3. #3
    Join Date
    May 2004
    Posts
    38
    Quote Originally Posted by MStef-ZG
    Try this in criteria:
    [name1] Or [name2] Or [name3]
    I tried that, it doesn't work. It still asks for just 1 name.
    Additionally, I need the Parameter to dynamic, so there's no set number of names that need to be entered. So that the user can put in as many as he/she wants.

  4. #4
    Join Date
    May 2004
    Posts
    38
    I found in this article one way of doing it :

    http://support.microsoft.com/kb/210530

Posting Permissions

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