Caculated Field Based on Two Fields from Different Tables

Posted on 2011-04-25
Last Modified: 2012-05-11
I need to create a report in Access that displays a calculated total from another report.  I have used the expression builder and the syntax of the expression is =[Reports]![SUMMARY OF ADDITIONS]![Sum Of Count]  All that shows up in the report view is #Name?  How can I get it to display the value that appears in the source report?

Also, once i get this figured out, I will need to subtract this field from another field that is identical in expression.  It just points to another report from another query.  How could I accomplish that?
Question by:marrj
    LVL 1

    Author Comment

    I just read one forum that said I would have to store the values from my report or query somehow to a table.  Then I could run a report off of them.  If this is correct, how would I do that?
    LVL 44

    Accepted Solution

    Just so we are clear"

    =[Reports]![SUMMARY OF ADDITIONS]![Sum Of Count]
    --------------------^this report is open-------^this is a control name in that report

    This value with the equal sign is inserted in a text box in a diffferent report - right?
    LVL 44

    Expert Comment

    Thanks, glad to help.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
    Outlook Free & Paid Tools
    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…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

    779 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

    15 Experts available now in Live!

    Get 1:1 Help Now