Report design question

[mergle]

I have a query that is the record source for a report...

Is it possible for a textbox on the report to reference a field that is not part of the record source?

If so, how exactly do I create the reference?

Thanks for any help!

 

[Rob.Mills]

Use a DLookUp function for that.

In the textbox's controlsource type:

=DLookUp("[FieldName]","[TableName]",Where Clause)

The where clause is optional. If you don't enter it the function will return the first record in the table.

 

[mergle]

Thank you much Rob.Mills...I'll give it a try