Results 1 to 2 of 2
  1. #1
    Jessica240 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2014
    Posts
    95

    Adding the values from 2 text boxes on different reports

    Hello! Does anyone know if it is possible to add the values from two different text boxes from two different reports? I have one main report that has a subreport in it. I need the total from the main report added to the total from the subreport to give me one grand total at the bottom.

    The main report and the subreport do not share the same control source - they get their data from 2 different queries. I don't have a way to link the queries so I'm not sure how to get around this.

    Any advice would be greatly appreciated! Thanks in advance!

    Jessica

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    In the subreport footer have textbox with the sum for the records on the subreport, named like tbxSubTotal.

    Then in the main report footer have a textbox that references the subreport textbox as well as sum the main report records, something like:

    =Sum([fieldname]) + [subreport container control name].Report.tbxSubTotal
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 3
    Last Post: 12-17-2013, 05:14 AM
  2. Reports positioning boxes with text content
    By pierre86 in forum Reports
    Replies: 2
    Last Post: 09-15-2013, 01:05 PM
  3. Replies: 5
    Last Post: 04-01-2013, 11:49 AM
  4. Replies: 3
    Last Post: 11-24-2012, 05:35 PM
  5. Replies: 10
    Last Post: 08-01-2009, 06:48 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