Access 2002: single record from table as report header?

[TheElephantMan]

Hi, all.

I have a report where its information is generated based on a single date value stored as the sole record in a table. When I try to display that date on the header of the report, I get "#Name?", instead.

A little assistance would be greatly appreciated.

Thanks in advance,
TEM

 

[M8KWR]

insert a text box and put something like

= "Report Name " & [FIELDNAME]

hope this helps

 

[TheElephantMan]

Hi, again.

Unfortunately, I get the same thing: "#name?". The table that I am pulling the information out of is not the same table/query as the source for the report. Could that be part of the problem?

Thanks, again.

TEM

 

[M8KWR]

You could use a parameter for the report header value.

Or if you are executing the report from a form, and the information you want displayed is contain somewhere on the form then you could use something like

="Report Name " & [forms]![form name]![control name]

 

[dhookom]

Try:
=DLookup("[TheField]","[TheTable]")

BTW: next time please provide your current expression that is causing the error as well as the table and field names.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.