Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jul 2003
    Location
    Notre Dame, Indiana, USA
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    report/ subreport parameter issue (A2k)

    The query from which my report gathers its data has a customer account number field, and a customer subnumber field. I have it set up to prompt me for the number [customer number] [customer subnumber]. When I run the report, I am prompted to enter the customer number and subnumber and all is well. <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23> However, I recently added a subreport to include data from another query. That query also prompts for the customer number and subnumber. Now when I run the report, I am prompted for the customer number and customer sub number TWICE, once for each part of the report, I presume, which makes sense, HOWEVER, I am prompted a third and fourth time before I can print the darn thing. <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15> What am I doing wrong? How can I make use of these prompts without being prompted over and over again? I have similiar issues with another report that prompts for start and stop dates. Any help you can give will be greatly appreciated.

  2. #2
    Star Lounger
    Join Date
    Sep 2003
    Location
    Houston, Texas, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: report/ subreport parameter issue (A2k)

    I do not think you are doing anything wrong. This is normal. Use a form to enter the criteria, then base the query that drives the report on what was entered on the form. You will not have the prolem this way.

Posting Permissions

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