Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)
-   -   Parameter Query (https://www.askmehelpdesk.com/showthread.php?t=474289)

  • May 28, 2010, 12:26 PM
    mcleyn
    Parameter Query
    Hi there,

    I have made a parameter query that is linked to a report, prompting the user with [What codes are you looking for?]. The Code field contains a variety of codes. However, when the parameter value shows up it only allows the user to choose one code and therefore only one code shows up in the report. I want the user to be able to choose more than one code. For instance if I wanted to see the report of 3 or even 4 codes. How can I make this possible?
  • May 28, 2010, 03:37 PM
    ScottGem

    I almost never use parameter prompt queries because they are so limiting.

    This article expalins how to use a multi-select listbox to supply parameters.
  • May 31, 2010, 07:49 AM
    mcleyn
    Quote:

    Originally Posted by ScottGem View Post
    I almost never use parameter prompt queries because they are so limiting.

    This article expalins how to use a multi-select listbox to supply parameters.

    Yes I agree with you. However, I will see what I can do with this article. Thanks again.

  • All times are GMT -7. The time now is 03:43 AM.