Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    8

    Unanswered: multiple parameter query

    I have a designed a query to pull information based on a project number. When I run the query, I can type in the criteria box "Proj1" or "Proj2" or "Proj3" and I will get the information for all three projects.

    I would like to put this query in a switchboard and prompt the user for the project number. I typed [Enter Proj Number] in the criteria box. When it prompts for the project number I cannot use "or" to get information on more than one project.

    Any idea how I can accomplish this. I do not want the user to have to query the database five different times to find the information on 5 different projects. I would like them to be able to enter the projects all at the same time.

    Thanks for any insight you can provide.

  2. #2
    Join Date
    Sep 2003
    Location
    Gloucester
    Posts
    28
    One way to achieve this is to:
    Add additional "OR" Criterial lines ie

    Criteria [Enter Project Nr]
    or [Enter 2nd Project Nr]
    or [Enter 3rd Project Nr]
    or [Enter 4th Project Nr]

    etc.

    The user does not have to enter data for every OR criteria line into the query - just hit return or OK at the point you want to stop.

  3. #3
    Join Date
    Sep 2003
    Posts
    8
    Thanks. I will give it a try.[


    QUOTE]Originally posted by Jumper
    One way to achieve this is to:
    Add additional "OR" Criterial lines ie

    Criteria [Enter Project Nr]
    or [Enter 2nd Project Nr]
    or [Enter 3rd Project Nr]
    or [Enter 4th Project Nr]

    etc.

    The user does not have to enter data for every OR criteria line into the query - just hit return or OK at the point you want to stop.
    [/QUOTE]

Posting Permissions

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