query results in reports

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ProteanBeing - 28 May 2008 23:06 GMT

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?

Reply to this Message

fredg - 28 May 2008 23:40 GMT

> 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.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message