Totals from another query

[AinsleyW]

I have a report that is based on a Query. On that report I would like to put the result from a second query (numerical - b/forward total) on the report also. I have an Unbounded text box on the report and has put the formula in the text box as =sum([secondqueryname]![fieldname]), however when I run the report the text box produces #Error.

How do I fix this please?

 

[RV]

You can't refer to another query, only to the one your report is based on.
That's your answer, see to it that your report is based on a query that includes both single queries.

RV