Text Box on Report?

[Randy]

I have set up a table with one record separate from my data table and
want to set up a text box on the top of the report to put the data from
the field in my single record table.

I can't seem to get this to work and get the #Error in the field. I
have put the name of the field using the build editor.

Can someone tell me what I need to do? The extra table is not linked.

 

[Rick B]

Is this field and table included in your report's data source (the query
upon which your report is based)?

 

[fredg]

I have set up a table with one record separate from my data table and
want to set up a text box on the top of the report to put the data from
the field in my single record table.

I can't seem to get this to work and get the #Error in the field. I
have put the name of the field using the build editor.

Can someone tell me what I need to do? The extra table is not linked.

I take it this table is not included in the report's record source.

Add an Unbound control to the report.
Set it's control source to:
=DLookUp("[Fieldname]","TableName")

Make sure the name of this control is not [FieldName].

 

[Randy]

Yes

 

[Rick B]

When you run the query, the field value you expect does show up for each
line in the query, right?

Then simply put the name preceeded by the equal sign in the unbound text
box. Or just drag the field from your field list.

 

[Randy]

That worked. Thanks