Using a specific field in a constants table as a Header in a report

[mpfohl]

I'm sure this is a fairly novice question re: accessing a table created
to hold database constants.

I have a database which i've created as a template to be shared with
many different users. Rather than re-customizing each report to have
their company's logo, name, web site, etc. for every new customer, I'd
like to have to just enter their contact info into a table once, and
then have the different reports look at that table to know what to put
in the header and footers of the different reports.

I know I need to create a table, which I'll call "ConstantsTable". One
column will be "Company Name", another "Phone number", etc. etc. I
really will only ever have one row in this table, but I could also
create an "IDnumber" field if that is easier to call up the info.

How do I then set up my textbox in my reports to call that specific
field to use as the page's header? I thought I may have to use
"dLookUp()" but I can't seem to figure out how to use it right.

Any suggestions?

 

[Duane Hookom]

Limit your constants table to a single record and just include the table in
your report's record source. You can add all the fields from your constants
table to make them available. You might also consider using subreports to
display your constants.

 

[mpfohl]

Unfortunatly, I would like my reports to use a variety of other queries
as their sources, i really only need the 'constants table' for a few
words here and there in the form. I could use the subform technique,
but each form i'd want different information included, so i'd have to
create multiple primary and secondary subforms.

I really just need a way to say "look at this table, look at this
column, and use whatever word in that field as the text in this box".

Is there a way to do that?

 

[Duane Hookom]

You can use DLookup() to pull a field value from a table.