I wish I saw this before I built the query (which worked) but this seems to
be a simpler solution. Thanks for posting.

"PBsoft" wrote:

I am trying to generate a report from information stored in table#1
that looks up organization names from table#2. When I include the
organization field from table#1 in my report, the report displays the
numerical value stored in table #1 not the actual text of the
organization name stored in table#2. How do I get the report to
display the text value from table #2? I'm just getting started with
access and tried finding this in a book I have and on the help topics
but to no avail. Any help would be greatly appreciated. Thanks.

You can use a combobox with the following rowsource:

SELECT OrgID, OrgName FROM table2, ORDER BY OrgName

Then set the ColumnWidths property of that combo to the following value:
0 cm, 3 cm

Comboboxes are displayed as textboxes onto reports, and with the "0 cm" column
you are hiding the value and showing the second column, the name.

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skypebsoftsolution