Header info from non-linked table

I have a report that I want to add a header. The header info comes from a
table other than the tbale that supplies data to the report. How do I do
that?

Patrick wrote:

I have a report that I want to add a header. The header info comes from a
table other than the tbale that supplies data to the report. How do I do
that?


You can use DLookup in a text box expression to retrieve a
value from the other table:
=DLookup("[header field]", "other table")

--
Marsh
MVP [MS Access]

Thanks, Marshall. I was lurking, and this morning, this post of yours
saved my hide

Thanks very much for sharing the usefulness of dLookup in providing a
report header(actually up to five lines of headers for me).

I appreciate it!!

On Mon, 09 Jul 2007 16:46:01 -0500, Marshall Barton
wrote:

Patrick wrote:

I have a report that I want to add a header. The header info comes from a
table other than the tbale that supplies data to the report. How do I do
that?


You can use DLookup in a text box expression to retrieve a
value from the other table:
=DLookup("[header field]", "other table")

Hey, it's a twofer ;-)

If you have more than just a couple of fields to lookup, it
would be more efficient to use code to open a recordset and
retrieve/set all the values once.
--
Marsh
MVP [MS Access]


gDareos wrote:

Thanks, Marshall. I was lurking, and this morning, this post of yours
saved my hide

Thanks very much for sharing the usefulness of dLookup in providing a
report header(actually up to five lines of headers for me).

I appreciate it!!

On Mon, 09 Jul 2007 16:46:01 -0500, Marshall Barton wrote:

Patrick wrote:

I have a report that I want to add a header. The header info comes from a
table other than the tbale that supplies data to the report. How do I do
that?


You can use DLookup in a text box expression to retrieve a
value from the other table:
=DLookup("[header field]", "other table")