How To Include Field From Unrelated Table In Report Header

  • Thread starter Thread starter rbdude
  • Start date Start date
R

rbdude

I have created a report based on a query that I have created, which works
just fine. However, now I want to display a text field from an unrelated
table in the report header. I tried creating a text field and indicating
the text is "=[TableXYZ!][Info]" where Info is the text field in a table
named TableXYZ that I want to display. But I get an #Error message. Does
anyone know how to do this?

Thanks in advance.
 
Check out the DLookup function in Help. It should do what you seek.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unusual Calculation in Report Header 1
Querying Unrelated Tables into One Report 2
Multiple Unrelated Queries In One Report or Form? 1
Report Header 2
Creating report using unrelated tables and shared parameters from 1 query 1
Create a report from two unrelated sources 1
Dynamic fields in report header 1
Descriptive headings in report header derived from report's name 7

Back
Top