Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Nov 2003
    Location
    Maryland, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Group totals incorrect (Access 2003/SP2)

    I have a report that calculates a group total. The total is correct unless the detail records in the group are continued on the next page and Repeat Section is set to "Yes". In this case, the group total only calculates the detail records on the next page. If I set Repeat Section to "No", the group total is fine. Can anyone give me some insight into this problem and maybe a solution? Thanks in advance!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Group totals incorrect (Access 2003/SP2)

    I can't reproduce the problem - I get the correct totals in both situations in a quick test. Could you post a stripped down copy of your database? See <post#=401925>post 401925</post#> for instructions.

  3. #3
    New Lounger
    Join Date
    Nov 2003
    Location
    Maryland, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Group totals incorrect (Access 2003/SP2)

    Hi Hans,

    I created a query to do the calculations and used that query in the report. All is fine now.

    The problem was within by VBA code. I was resetting the values in the group header format, which caused the totals to be wrong.

    Thanks again for replying!

Posting Permissions

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