"Seperate" query on a textfield?

[Mikael Lindqvist]

Hi,

I have a basic report that list data from a query (customer name, invoide
number, invoice date, amount)

Now, in my report-header I want to include a field from an "external" query.
I have created a bounded textfield and written:

=[query_name]![field_name]

But when I run the report I'm asked to include the "parameter value" for the
"query_name".

I guess I'm doing something wrong here....

Kindly
Mikael
Sweden

 

[Dennis]

Assuming your external query has more than 1 row, you will need to tell it
which row to access by supplying some form of criteria (basically a SQL where
clause without the word WHERE). If there is only 1 row in your query then you
can omit the criteria part of the DlookUp function.
e.g.
=DLookUp("[FieldName]","[QueryName]","Criteria")