We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now


Caculated Field Based on Two Fields from Different Tables

Medium Priority
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?
Watch Question


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?
Unlock this solution and get a sample of our free trial.
(No credit card required)

Thanks, glad to help.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.