Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a report containing names of students for a given school. At the end of the report is a subreport containing the number of students of each nationality within that school and then a grand total. Everything works well unless the subreport is long and breaks to a second page. When that happens, the nationality that is first on the second page is increased by 1 more than it should be and the grand total is increased by 1 as well. If I open the subreport by itself and it fits on one page then the totals are correct. Is there a way to tell the subreport to substract 1 when it needs to go to a second page?
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Can you tell us how the subreport calculates the number of students per nationality? Thanks.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The detail section which is not visible contains a textbox called NatCnt with the control sourse =1 for each Student# and the running sum is set to "Over Group".

    There is a program location header and footer and within each program location there is a nationality footer displaying the name of the nationality and two text boxes, one sums the NatCnt field and the running sum is = "No". The second textbox which is not visible, sums the NatCnt field and the running sum is set to "Over Group" in order to display the county total for all students in the report footer.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Instead of using text boxes whose Running Sum property has been set to Over Group or Over All, use "normal" text boxes with control source

    =Count(*)

    The text boxes will display the number of records within the group / report.

  5. #5
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts
    That solution fixed the problem. I would have thought that both calculations would have provided the same results but I see now that there is a difference. Thanks for your help
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I suspect the problem with the running sum text boxes is a bug in Access. It doesn't occur in a main report, as far as I know.

Posting Permissions

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