query results in reports

[ProteanBeing via AccessMonster.com]

I created a one line query that gives me the total Weight scrapped for the
selected month. When I run the query it works! When I try to put that value
in a text box of a report I get #Name? What am I doing wrong?

 

[fredg]

I created a one line query that gives me the total Weight scrapped for the
selected month. When I run the query it works! When I try to put that value
in a text box of a report I get #Name? What am I doing wrong?

#Name errors occur when Access does not recognize the field name used
in the control.
How are you trying to put that value into the report?
What is the exact control source of that control?

Any way, if the query is not the report's record source and returns
just one record, you can refer to the field in the query in an unbound
control on the report, using:

=DLookUp("[FieldName]","QueryName")

Change [FieldName] and QueryName to the actual names used.

Make sure the name of this control is not the same as the name of any
field used in it's control source expression.