Header info from non-linked table

[Guest]

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?

 

[Marshall Barton]

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")

 

[gDareos]

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!!

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")

 

[Marshall Barton]

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]

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!!

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")