Results 1 to 2 of 2
  1. #1
    cmk Guest

    not correct running total in group

    I am in a report, I have several groups and I want to receive a subtotal on
    purchase price in my stock type group. My problem is there are several
    detail lines and my original value is adding into the subtotal for each
    detail line.

    I attempted to put a visible field in the group header and a running sum.


    Then take that field and put in the group footer without any luck.

    Any help will be appreciated

  2. #2
    Join Date
    Dec 2006
    Posts
    5
    Assuming your subtotal is printing in a group footer section, then you may need to clear it after it prints. The best way to do this is probably to insert a "subtotal=0" in the header section associated with the footer (in the VBA module). That way it will be sure to print the value before it clears.

    jb

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Running Queries from a form
    By HaYuM in forum Queries
    Replies: 1
    Last Post: 08-23-2013, 03:12 AM
  2. Replies: 4
    Last Post: 08-19-2011, 01:53 PM
  3. Replies: 1
    Last Post: 03-12-2009, 09:55 AM
  4. Top 2 by group
    By griz in forum Access
    Replies: 0
    Last Post: 05-25-2008, 07:10 AM
  5. Adding Running Balance from Form to Reports
    By KIDGEO3 in forum Reports
    Replies: 1
    Last Post: 01-18-2006, 08:52 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums