Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report criteria...

    I have two reports (1 summary, 1 detailed) that are based on a query which is in turn based on a query of one table !
    When i run either report i am asked to supply certain criteria - week numbers, project code etc. They are requested once only. These are required by the two queries to filter the data. However, when i place the summary report in the detail report footer i am asked for the criteria 6 times.
    Why ?
    How do I stop this ?

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

    Re: Report criteria...

    In order to avoid this, I collect the criteria in a dialog form and then run the report from the dialog form. This way, no matter how many times the object wants the parameters, it can find them on the form and leave the user in peace.

    You can find the directions for creating this in the Access Help Index. Search on "criteria, reports". Then, "use a form to enter report criteria".

Posting Permissions

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