Passing values between reports

[Majed]

Here is the deal,
I have a billing system that uses multiple reports. All reports get open
when I run the system. Everything works fine when there is data in all the
reports, and data summaries gets passed from all reports to the summary
report. Sometimes in one or more reports in a certain month, there is no
data, and instead of passing 0 (zero) from the these reports that do not have
data to the summary reports. I get #Error or #Name. (The summary values to be
passed are usually in the footer section of the reports)
I use this on the summary report to get the values from the reports to the
summary report: Reports![Report name that I wanna get the summary from]![Name
of summary value that is gonna be passed]
(!) or (.) I don't think it makes a difference.

 

[Duane Hookom]

I would never have a value in one report depend on a value from another
report unless they were report with subreport. Values come from tables. Use
queries to pull your values.