Results 1 to 5 of 5
  1. #1
    kcm4491 is offline Novice
    Windows Vista Access 2007
    Join Date
    Nov 2010
    Location
    Nagasaki
    Posts
    12

    Question Showing total from a subreport in the main report

    I have data in a subreport that I want to show the total of in the main body of the report. I have been tried using "=Sum(field name)", but it is not working.



    Is there a way to get this to work?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    You put a sum in the subreport's report footer, and then in the main report just point to that. You may want this too:

    http://www.mvps.org/access/forms/frm0022.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    kcm4491 is offline Novice
    Windows Vista Access 2007
    Join Date
    Nov 2010
    Location
    Nagasaki
    Posts
    12

    Cool

    Thank you, I am trying that now, getting the error and trying to solve it now.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    No problem, post back if you get stuck.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    kcm4491 is offline Novice
    Windows Vista Access 2007
    Join Date
    Nov 2010
    Location
    Nagasaki
    Posts
    12

    Talking

    Thank you once again. I figured out where the error was. I had placed the text box in the Page Footer, instead of the Report Footer. Everything works fine now.

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

Similar Threads

  1. Grand total of field on a subreport
    By degras in forum Reports
    Replies: 9
    Last Post: 02-03-2011, 12:09 PM
  2. Adding a total to a subreport?
    By degras in forum Reports
    Replies: 3
    Last Post: 01-25-2011, 10:30 AM
  3. Replies: 3
    Last Post: 06-23-2010, 02:02 PM
  4. Report and Subreport
    By newbie in forum Reports
    Replies: 0
    Last Post: 02-16-2010, 12:14 PM
  5. Replies: 0
    Last Post: 10-24-2008, 11:20 AM

Tags for this Thread

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