Results 1 to 4 of 4
  1. #1
    bullis
    Guest

    Paramater requests

    Hello,
    I have a report that is made up of several queries and sub-reports.

    The paramater is "Grower Number" for this report. When I run the report, it asks me for the "Grower Number" repeatedly instead of just one time. I think it is asking me for the Grower Number for each query and each sub-report.

    How can I have it just ask me for the parameter one time?

    Thank you very much

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paramater requests

    Take a look at this:

    http://www.wopr.com/cgi-bin/w3t/showthread...og&Match=Entire Phrase&Searchpage=1&Limit=25&Old=allposts&Main=428 34

    (Can someone please tell me if this is the right way to link to a previous post ... should the full path show like this?
    Thank you)

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Paramater requests

    The first thing is that you need to make sure you have specified [Grower Number] EXACTLY the same each time. Even a slight difference will cause Access to treat them as separate variables.

    You may not need to specify [Grower Number] in the subreports if you setup the subreport control specifying the master/child links.

    BTW, what sort of application is this?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Paramater requests

    Hi Thomas,
    It's entirely up to you! You can show the whole URL using
    [ url]http://www.wopr.com[ /url]
    or you can use
    [ url=http://www.wopr.com]Woody's Lounge[ /url]
    to show a description instead.
    (I've added spaces so you can see the tags)
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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