Report Header

[RCR]

My database runs a lot of Reports based on several tables. The Header for
each report contains text that is identical in each report. As the text used
in header is not based on any table data, I create it using labels. However,
I occaisionally need to update this header, which means I have to manually
edit the report header of all reports.
I have tried creating a small table containing header info, which would let
me amend the table, thereby updating all report headers. The problem with
this is I cannot link this new table to all my other tables, to create
reports.
Is there a way of creating Report header info and adding it to Reports
without being linked to Report data?

 

[Allen Browne]

Say you created a table named Table1, with a memo field named Head4Report,
you could use DLookup() on your report to read that data.

The Control Source of the text box on the report would be:
=DLookup("Head4Report", "Table1")

More info about DLookup() in this article:
Getting a value from a table
at:
http://allenbrowne.com/casu-07.html

 

[RCR]

Allen

Thankyou very much for your help. Much appreciated.