In a Report, how do I display the text not the ID value?

[Guest]

I am trying to generate a report from 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.

 

[Douglas J. Steele]

Sounds like you've used that misguided misfeature known as the Lookup Field
(see http://www.mvps.org/access/lookupfields.htm at "The Access Web" for
some of the reasons why many of us feel this way)

You're going to have to create a query that joins together the two tables in
order to include the text from table#2, and then use that query as the
RecordSource for your report, rather than simply using table#1.

 

[Joseph Meehan]

I am trying to generate a report from 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 need to mak sure you have a proper relationship set up between the
two tables and I suggest setting up a query including both related tables
and use that as your record source.

 

[Guest]

For the report's RecordSource use a query which joins the two tables on the
numerical ID number fields, and which includes the organization name from
table#2 as a column in the query's output. You can then bind a control in
the report to the organization name column rather than the ID number.

Ken Sheridan
Stafford, England

 

[Guest]

Thanks for everyone's help. I did a query and it worked.