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?