• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 232
  • Last Modified:

Caculated Field Based on Two Fields from Different Tables

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?
0
marrj
Asked:
marrj
  • 2
1 Solution
 
marrjAuthor Commented:
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?
0
 
GRayLCommented:
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?
0
 
GRayLCommented:
Thanks, glad to help.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now