Comparing results from subreports

Posted on 2005-05-01
Last Modified: 2006-11-18
I have a report that has two subreports on it.  I need to divide the totals from one subreport by the totals from the other subreport on the main report.  How is this done?
Question by:AaronGreene1906
    1 Comment
    LVL 27

    Accepted Solution

    assuming your sum1 is from Subreport1, and sum2 is from Subreport2,
    make an unbound textbox in the Report call it sum12, where the Control Source of it should be:
    =Reports![Report Name]![SubReport1 Name]![sum1] / Reports![Report Name]![SubReport2 Name]![sum2]


    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now